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.
2016-10-20, 637👍, 0💬
Popular Posts:
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How To Download Oracle Database 10g XE in Oracle? If you want to download a copy of Oracle Database ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...