Unable to access database after change to users AD Permissions

Ctrl + k

Published a year ago

We have a user who is not able to access the PVM database currently. The change in the enviroment was this user was a domain admin and all domain administrator permissions have been removed from the user. The error message I am getting is

The SELECT permission was denied on the object 'DatabaseInfo', database 'PVM' Schema 'dbo'.

Implement the database login mode - Devolutions Documentation

All Comments (4)

Stéfane Lavergne

Published a year ago

Please try the following: https://docs.devolutions.net/rdm/kb/how-to-articles/database-login-mode/#troubleshooting

Stéfane Lavergne

magarner

Published a year ago

Click the fix worked however it did give me the following message

dd868a22-6e3f-4cc4-a35c-b1a2330c430e.png

Stéfane Lavergne

Published a year ago

You can ignore this error, RDM was trying to remove the user from the db_owner role but the user doing the action must likely doesn't have permissions to do so.

Chances are the user isn't/wasn't even part of the db_owner role to start with, so it's not a big deal.

You can validate, if you want via SSMS (SQL Server Management Studio), right-click > properties on the db_owner role of your RDM database and see the list of users that are part of the group.

Best regards,

Stéfane Lavergne

94025b27-1208-467f-988d-40178a62705f.png

magarner

Published a year ago

Thank you for the help and the quick response