Hi,
I may have missed it but is it possbile to have RDM also delete the SQL Server database user when a user is removed/deleted in RDM?
Regards,
Jan-Pieter
Hi,
I will enter a feature request that will prompt and ask you if you want to delete the SQL Server user.
Regards
David Hervieux
Hi, as far as I can see this feature request hasn't made it to production yet.
Do you have any idea when this will be implemented?
Hi,
I will double check this with Stefane next Monday. I know that we were missing 1 piece of the puzzle and I think that we will have this soon.
David Hervieux
This doesn't seem to have been implemented yet?
I have checked RDM 11.5.4.0 (64-bit)
It's now implemented in for the SQL Server data source only and will be available in the next beta release.
If the user has a login (matching name) then the system will prompt the user asking to delete or not the login.
Why "matching name"? Well, logins and users are two different things in SQL server. When RDM creates a login with corresponding user then all will work as expected In the case where say a DBA creates the login 'user_a_login' and links that to a user called 'RDM_user_a' in the RDM database (manually of course) then in this case we will not prompt nor will we delete the login. Yes, it's a corner case but putting it out there.
Best regards,
Stéfane Lavergne
6-20-2016 11-17-49 AM.png
I can confirm it works in 11.6.0.0 (64-bit). Tnx! :)