Re: Viewing object owner in SQL 2005 - ownership chaining
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 14 Dec 2007 22:41:59 +0000 (UTC)
Wayne Erfling (wayne_erfling@xxxxxxxxxxxxxx) writes:
One question in particular remains in my mind:
I see that the owner is not the schema itself, so it must be a USER
entity, or a LOGIN entity, or some dynamic combination of them (e.g.
join the user to the current login and make the comparision based on
the login).
The owner of a database object is a database principal. A database
principal is a user, a role, an application role or a Windows group.
The owner of a server-level object such as a database, is a server
principal, of which a login is the prime example.
A database principal often maps to a server principal, for instance if
you do:
CREATE LOGIN svante WITH PASSWORD = 'sture'
go
USE somedb
go
CREATE USER svante
There is now a login, which can access the database somedb. He is known
as svante both at server level and in the database. This is convenient,
but the mapping itself is on a SID, and the names could be different
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- References:
- Re: Viewing object owner in SQL 2005 - ownership chaining
- From: Dan Guzman
- Re: Viewing object owner in SQL 2005 - ownership chaining
- From: Wayne Erfling
- Re: Viewing object owner in SQL 2005 - ownership chaining
- Prev by Date: Re: Backup Restore of DB
- Next by Date: Re: SQL Server Mode
- Previous by thread: Re: Viewing object owner in SQL 2005 - ownership chaining
- Next by thread: Re: Viewing object owner in SQL 2005 - ownership chaining
- Index(es):
Relevant Pages
|
|
