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, 1277🔥, 0💬
Popular Posts:
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How To Use GO Command in "sqlcmd" in SQL Server? "sqlcmd" is a command line client application to ru...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...