I have been working as a developer with SQL Server for years without asking the question, "what is dbo
", a shame. Recently I have been studying the security model of SQL Server 2008. I have been overwhelmed by lots of concepts. Please clarify some concepts for me, and correct me where I am wrong. I don't need a thorough explanation on everything, just an idea what does what and the relationships involved:
LOGIN: Server level (SQL Server login or Windows login).
USER: Database level (a user is mapped to a login).
ROLE: Users belong to a role. Can be at server level or at database level
with permissions attached.
SCHEMA: Database objects belong to a schema (or dbo by default)
PERMISSION:
For database objects or schema. A user or a role has permissions for
an object or a schema.
OWNER: Is it the user who created a object or schema? What does it do?
How does it work? Where I can see the owner of a object in SSMS?
I see only schema.object