Collections:
Security Model Used in SQL Server 2005 in SQL Server
What Is the Security Model Used in SQL Server 2005 in SQL Server?
✍: FYIcenter.com
SQL Server 2005 uses a very standard security model involves 3 concepts:
In simple terms, a principal answers the security question of "Who are you?"; a securable answers the security question of "What is your target object?"; a permission answers the security question of "You are allowed to perform this action on this target object".
SQL Server 2005 supports multiple securables and multiple principals organized
into hierarchical structures as shown in this picture:
(Picture by Microsoft)
2016-10-20, 616👍, 0💬
Popular Posts:
How To Display a Past Time in Days, Hours and Minutes in MySQL? You have seen a lots of Websites are...
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...