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, 988👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Storage Engines: MyISAM, InnoDB and BDB in My...
How To Define an External Table in a Text File in Oracle? You can use the CREATE TABLE statement to ...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...