Link to home
Create AccountLog in
Avatar of anushahanna
anushahannaFlag for United States of America

asked on

db owner vs sa

is DB owner database role equivalent of SA for just that database?
ASKER CERTIFIED SOLUTION
Avatar of Marbleman
Marbleman

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of anushahanna

ASKER

OK. What i meant is, just like sa has all permissions on the server (at the server level, and hence also at database level), db_owner has such privileges at a database level, right?

in other words, whatever a sa can do on a database, a db_owner can do the same in that database, right, in terms of permissions? they will have equal rights at that database, correct?
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Qlemo, that is a good point that sa is a user/login, where as db_owner is something you give to a user/login. thanks.

the doc says db_owners can be do all configuration and maintenance activities on the database
http://msdn.microsoft.com/en-us/library/ms180977%28SQL.90%29.aspx

is there another reference of what exactly is and is not "configuration and maintenance activities on the database"

in your description, can you confirm i am co-relating correctly?
the session list - is that sp_who2?
locks - sp_lock?
not be able to change security - GRANT command?
database link to another server - Linked server?

thanks again.
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
so db_owner has comprehensive privileges on the database, but not as much as sa, right?

there is no other role more 'powerful' than db_owner, that you can assign, just for a database, is there?
SOLUTION
Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Thanks Qlemo.