SQL integrated security permissions

SQL integrated security permissions

avatar

I have SQL permissions specified as follows:

Database 1:
Group 1:
sysadmin (role)
Group 2:
db_owner
public
Group 3:
db_datareader
public

Group 2 does not have the ability to modify the RDM database. Group 1 does. If Group 2 is added to the sysadmin role the users can make changes to the RDM database.

Are there any other system databases and/or permissions that the users should have to allow changes to the RDM database(s)?

Thanks!

All Comments (3)

avatar

Hi,
What version do you have, because I added db_owner as administrator in the latest version (5.6.2.0). You can also add the user in RDM and configure him directly in the application.

David Hervieux
Devolutions inc.

David Hervieux

avatar

I was using 5.6.1.0 for testing. I will test again with 5.6.2.0. Thanks for responding!

avatar

This works perfectly in 5.6.2.0. :)