Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


dbo vs db_owner?


dbo vs db_owner?

Author
Message
bugop
bugop
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 581
What is the difference between these two database roles?. and which one has the full control of the database. As i understand it dbo, is the owner of the database. Why then are we having the db_owner rols?
Lowell
Lowell
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14942 Visits: 38937
bugop (11/9/2009)
What is the difference between these two database roles?. and which one has the full control of the database. As i understand it dbo, is the owner of the database. Why then are we having the db_owner rols?


only one of them is a role. db_owner is a role, and you could have multiple users tied to that role.

obviously, the role db_owner decides what objects you are allowed to fiddle with and what rights the user has.

dbo is the schema that the objects belong to...in SQL 2000, it was actually the user the objects belonged to, but it has been abstracted out. the schema is used to logically collect groups of objects.

dbo is also the "default" schema that is used if the schema is not specified.

you can create a multiple schemas in a database if you want, and each schema could have a table with the same name, so dbo.Invoices could exist right along side of Production.Invoices.

I could create a different role that has onl,y permissions for the Production schema, where db_owner has access to all schemas.
hope that helps

Lowell

--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

bugop
bugop
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 581
very clear, thanks a lot!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search