|
Home > Archive > MS SQL Server > April 2005 > members of db_owner can't mangage roles?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
members of db_owner can't mangage roles?
|
|
| AlexB_05 2005-04-27, 8:23 pm |
| I have two people assigned to the db_owner role in a database and they can do
everything except manage users and roles. For example when they try to look
at the properties of a role in EM they get the following error message:
Error229: EXECUTE permission denied on object ‘sp_helprolemember
’, database
‘master’, owner dbo
(The same thing happens in QA)
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
the database as well as making them members of the securityadmin server role.
None of this worked either.
Any suggestions?
| |
| Sue Hoegemeier 2005-04-28, 3:23 am |
| Did you check for user, roles denied execute on the stored
procedure?
use master
go
sp_helprotect 'sp_helprolemember'
-Sue
On Wed, 27 Apr 2005 14:22:07 -0700, "AlexB_05"
< AlexB_05@discussions
.microsoft.com> wrote:
>I have two people assigned to the db_owner role in a database and they can do
>everything except manage users and roles. For example when they try to look
>at the properties of a role in EM they get the following error message:
>
>Error229: EXECUTE permission denied on object ‘sp_helprolemember’,
database
>‘master’, owner dbo
>
>(The same thing happens in QA)
>
>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
>the database as well as making them members of the securityadmin server role.
> None of this worked either.
>
>Any suggestions?
| |
| AlexB_05 2005-04-28, 1:23 pm |
| That was it. Somehow the public role did not have permission to execute
sp_helprolemember. Once I granted those permissions everything worked.
"Sue Hoegemeier" wrote:
> Did you check for user, roles denied execute on the stored
> procedure?
> use master
> go
> sp_helprotect 'sp_helprolemember'
>
> -Sue
>
> On Wed, 27 Apr 2005 14:22:07 -0700, "AlexB_05"
> < AlexB_05@discussions
.microsoft.com> wrote:
>
>
>
|
|
|
|
|