Difference between revisions of "SQL Server 2008"
From MyWiki
| Line 3: | Line 3: | ||
http://msdn.microsoft.com/en-us/library/bb669061%28v=vs.110%29.aspx<br> | http://msdn.microsoft.com/en-us/library/bb669061%28v=vs.110%29.aspx<br> | ||
http://blogs.msdn.com/b/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx logins and users <br> | http://blogs.msdn.com/b/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx logins and users <br> | ||
| + | A login is the principal that is used to connect to the server. A user is the principal that is used to connect to a database. | ||
Revision as of 14:51, 20 June 2014
Because the owner is the root of trust. It is the owner that grants, denies and revokes permission on the object
http://www.sqlteam.com/article/understanding-the-difference-between-owners-and-schemas-in-sql-server
http://msdn.microsoft.com/en-us/library/bb669061%28v=vs.110%29.aspx
http://blogs.msdn.com/b/lcris/archive/2007/03/23/basic-sql-server-security-concepts-logins-users-and-principals.aspx logins and users
A login is the principal that is used to connect to the server. A user is the principal that is used to connect to a database.
