Collections:
Security Principals Used in SQL Server 2005 in SQL Server
What Are Security Principals Used in SQL Server 2005 in SQL Server?
✍: FYIcenter.com
SQL Server 2005 supports several basic security principals located at different levels:
To access a SQL Server instance, you must use a Windows login or a SQL Server login previously created in that server instance. Once you logged in, you are represented by this login name as your security principal at the server level.
If you select a specific database in the server to use, SQL Server will search that database for a previously user that has been mapped to your login name. If that user is located, you are represented by this user name as your security principal at the database level.
⇒ Suser_Sname() - Sever Level Security Principal of Your Session in SQL Server
⇐ Security Model Used in SQL Server 2005 in SQL Server
2016-10-20, 1074👍, 0💬
Popular Posts:
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
How to execute statements under given conditions in SQL Server Transact-SQL? How to use IF ... ELSE ...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...