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
AdaptAdmin and user
AdminSapr in database.
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?