I seem to be having trouble understanding how the db_owner role works. It doesn't seem hard, as the documentation says that users assigned to this role have all permissions in the database.
I have two people assigned to this and they can do everything except manage users and roles. For example when they try to look at the properties of a role in Enterprise Manager they get the following error message:
Error229: EXECUTE permission denied on object ‘sp_helprolemember’, database ‘master’, owner dbo
In master, the public role has permission to execute sp_helprolemember and both of these users are members of the public role in master.
I also tried adding them to the db_accessadmin and db_securityadmin roles in addition to the db_owner role.
They are also members of the securityadmin server role.
Any suggestions?
I have two people assigned to this and they can do everything except manage users and roles. For example when they try to look at the properties of a role in Enterprise Manager they get the following error message:
Error229: EXECUTE permission denied on object ‘sp_helprolemember’, database ‘master’, owner dbo
In master, the public role has permission to execute sp_helprolemember and both of these users are members of the public role in master.
I also tried adding them to the db_accessadmin and db_securityadmin roles in addition to the db_owner role.
They are also members of the securityadmin server role.
Any suggestions?