September 25, 2015 at 2:41 am
Hi,
I'm on SQL Server 2014. Trying to add my user to a group. I use the following:
exec sp_addrolemember 'MyGroup', 'DOMAIN\jbloggs'
I then check it using:
select IS_MEMBER('Underwriting')
however it says no. I checked the usual things - the group is preexisting, my username is correct. I'm using SSMS as admin. I'm confused why it's not working...
Can anyone help pls?
J.
September 25, 2015 at 2:53 am
Do you have any of the following rights?
Membership in the db_securityadmin or db_owner fixed database role.
Membership in the role that owns the role.
ALTER ANY ROLE permission or ALTER permission on the role.
If not you don't have permission to add yourself to the role.
September 25, 2015 at 9:24 am
Thanks. I figured this out. I''m a db owner and cannot belong to both.
J.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply