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, 1347🔥, 0💬
Popular Posts:
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
How To Fix the INSERT Command Denied Error in MySQL? The reason for getting the "1142: INSERT comman...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...