roles

Question

Post reply

roles

bruce_reid

SSCrazy

Points: 2419
More actions
April 14, 2003 at 8:26 am

#80734

I have a server A and databases A1,A2,A3,A4,A5,A6.How to give a db_owner permission to all the server(i,e on A)

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Allen Cui-55137 SSC Guru Points: 51650 More actions · Answer 1

Don't understand your question. Can you post more information?

bruce_reid SSCrazy Points: 2419 More actions · Answer 2

I have a server namesd A and in that I have 6 databases A1 to A6.I wanted to give the db_owner permission all the databases(A1 to A6)on A.So how to do that in efficiant way

dj_meier SSCrazy Points: 2732 More actions · Answer 3

You can grant the db_owner role in each database to a specific user.

-Dan

bruce_reid SSCrazy Points: 2419 More actions · Answer 4

Instead of giving in a each database individually can i give it at server level

tcartwright SSCertifiable Points: 5573 More actions · Answer 5

1) Are you looking to grant them "sa" privileges?

A) Assign the login the "System Administrators" server role. They now have "sa" rights.

2) Just give them db_owner rights to just those databases?

A) Give the login rights to each DB, and assign it the db_owner database role for the rights. Example :

 

USE A1

GO



EXEC sp_grantdbaccess @loginame = 'login'

GO



IF @@ERROR = 0 

BEGIN

EXEC sp_addrolemember @rolename = 'db_owner', @membername = 'login' 

GO

END

3) Grant db_owner to all databases on your server?

A) Repeat step 2 till done.

Be aware the db_owner role is a powerful role to grant to a user. What purpose are you trying to accomplish by giving them this right? I would suggest a combination of other roles before resorting to db_owner.

Tim C //Will code for food

dj_meier SSCrazy Points: 2732 More actions · Answer 6

Fixed server roles cannot be created, but you can assign a server role to a server login. I believe the only server role that has db_owner/dbo rights in all databases is sysadmin role. An object created by a user with sysadmin role is always owned by dbo, but a user with db_owner role in a specific database must specify the owner as "dbo", otherwise the object will be created with that user as the owner.

-Dan

bruce_reid SSCrazy Points: 2419 More actions · Answer 7

Hi,thanks for your help in this.I really appreciate it..