Difference between revisions of "SQL Server 2008"
From MyWiki
| Line 6: | Line 6: | ||
http://www.sqlservercentral.com/blogs/brian_kelley/2009/04/21/sql-server-security-basics-logins-vs-users/<br> | http://www.sqlservercentral.com/blogs/brian_kelley/2009/04/21/sql-server-security-basics-logins-vs-users/<br> | ||
https://www.youtube.com/watch?v=c3gPdKaLlkg This is quite good<br> | https://www.youtube.com/watch?v=c3gPdKaLlkg This is quite good<br> | ||
| + | https://www.youtube.com/watch?v=9Zj5ODhv0b0&list=PL08903FB7ACA1C2FB&index=6 good series of tutorials <br> | ||
Revision as of 11:05, 30 August 2015
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
Logins and Users in SQL Server
http://www.sqlservercentral.com/blogs/brian_kelley/2009/04/21/sql-server-security-basics-logins-vs-users/
https://www.youtube.com/watch?v=c3gPdKaLlkg This is quite good
https://www.youtube.com/watch?v=9Zj5ODhv0b0&list=PL08903FB7ACA1C2FB&index=6 good series of tutorials
