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, 1245🔥, 0💬
Popular Posts:
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
What Are Out-of-Range Errors with DATETIME values in SQL Server Transact-SQL? When you enter DATETIM...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...