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. :)