December 18, 2014 at 10:21 am
Hello all-
Here’s the situation I am hoping someone can guide me with please:
•User wants to be able to backup and restore databases
•User also wants to be able to grant db_owner to user logins
What I have tried:
•I’ve granted them db_creator and securityadmin, however the user cannot map logins to the database with db_owner permission
•Tried through the GUI and also t-sql
use [database]
go
exec sp_addrolemember 'db_owner', ‘sqlaccount’
go
Error:
Cannot alter the role 'db_owner', because it does not exist or you do not have permission.
Any ideas would be much appreciated!
Thank you in advance!
December 18, 2014 at 2:34 pm
to grant DB_Owner you must be a member of the DB_Owner database role or sysadmin server role
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2014 at 2:28 am
This was removed by the editor as SPAM
December 19, 2014 at 4:31 am
Thanks jacksonandrews321 for the link you provided. I was searching information about the dlladmin role and now I have understood it.
Have a nice day.
December 19, 2014 at 4:56 am
patricklambin (12/19/2014)
Thanks jacksonandrews321 for the link you provided. I was searching information about the dlladmin role and now I have understood it.Have a nice day.
What's ddladmin got to do with it?????
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 19, 2014 at 10:34 am
Hi Perry Whittle ,
In the link you provided , I found information valuable for me , a way to tell you thanks.
Have a nice day
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply