I'm trying to execute this script from Management Studio:
GRANT ALTER ON ROLE::[AdaptTemplate] TO [AdaptAdmin] AS [AdminSapr]
Execution fails with this message:
Msg 15151, Level 16, State 1, Line 1 Cannot find the role 'AdaptTemplate', because it does not exist or you do not have permission.
There are existing roles AdaptTemplate
, AdaptAdmin
and user AdminSapr
in database.
User AdminSapr
is a member of db_owner
. My current login (which I'm trying to execute script from) is a member of sysadmin
server role.
What am I doing wrong?
sysadmin
)?AdminSapr
hasn't sufficient rights to grant alter role.GRANT ALTER ON ROLE::[AdaptTemplate] TO [AdaptAdmin]
(so, instead ofAdminSapr
I'm using security context of my current login), then it being executed successfully.