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, 1287🔥, 0💬
Popular Posts:
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...