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, 1364🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...