Remove database user after deleting user in RDM

Remove database user after deleting user in RDM

avatar
jan-pieter
Disabled

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

All Comments (6)

avatar

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

avatar

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?

avatar

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

avatar

This doesn't seem to have been implemented yet?
I have checked RDM 11.5.4.0 (64-bit)

avatar

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

avatar

I can confirm it works in 11.6.0.0 (64-bit). Tnx! :)