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:
⇒ Security Principals Used in SQL Server 2005 in SQL Server
⇐ Managing Security, Login and User in SQL Server
2016-10-20, 1270🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Convert Binary Strings into Integers in SQL Server Transact-SQL? Binary strings and integers ...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
How To Recover a Dropped Index in Oracle? If you have the recycle bin feature turned on, dropped ind...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...