SQL Server 2005 supports several basic security principals located at different levels:* Windows-Level Principals: Windows Local Login and Windows Network Domain Login - Used to control accesses to SQL Server instances.* SQL Server-Level Principal: SQL Server Login. - Used to control accesses to SQL Server instances.* Database-Level Principal: Database User. - Used to control accesses to database instances.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.
Database
Topic: SQL SERVER
What Are Security Principals Used in SQL Server 2005?
Browse random answers:
How To Rebuild Indexes with ALTER INDEX ... REBUILD?
How To Execute the Cursor Queries with "OPEN" Statements?
How To Change the Name of a Database User?
How to set a database state to OFFLINE in MS SQL Server?
What is a database table?
How To Update Values in a Table with UPDATE Statements in MS SQL Server?
How To Use Values from Other Tables in UPDATE Statements in MS SQL Server?
How to provide column names in INSERT Statements in MS SQL Server?
What Are DML (Data Manipulation Language) Statements in MS SQL Server?
How To Join Two Tables in a Single Query in MS SQL Server?
How To Name Query Output Columns in MS SQL Server?
Can Multiple Columns Be Used in SQL GROUP BY Clause in MS SQL Server?
What Is SQL Language?
How To Start and End Transact-SQL Statements?
What Are Character String Data Types in MS SQL Server?
How Many Categories of Data Types Used by SQL Server?
What Are the Differences between DECIMAL and FLOAT in MS SQL Server?
How To Create User Messages with PRINT Statements in MS SQL Server?
How To Write Character String Constants or Literals in MS SQL Server?
What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server?
How To Enter Unicode Character String Literals in MS SQL Server?
What Are the Differences between CHAR and VARCHAR in MS SQL Server?
How To Enter Binary String Literals in MS SQL Server?
What Are the Underflow and Overflow Behaviors on FLOAT Literals?
What Happens If an Integer Is Too Big for INT Date Type?
How To Generate Random Numbers with the RAND() Function in MS SQL Server?
What Are the Mathematical Functions Supported by SQL Server 2005?
What To Perform Pattern Match with the LIKE Operator?
How To Execute a Stored Procedure in MS SQL Server?
How To Bind a View to the Schema of the Underlying Tables?
How To Use Wildcard Characters in LIKE Operations in MS SQL Server?
How To Use "IF ... ELSE IF ... ELSE ..." Statement Structures in MS SQL Server?
How To Get the Definition of a Stored Procedure Back?
Can You Pass Expressions to Stored Procedure Parameters?
Why I am getting "The Microsoft .Net Framework 2.0 in not installed" message?
System Requirements for SQL Server 2005 Express Edition?
How To Use User Defined Functions in Expressions?
How to grant a permission in MS SQL Server using "GRANT EXECUTE" statements?
How to create a user to access a database in MS SQL Server using "CREATE USER" statements?
How to connect SQL Server Management Studio Express to SQL Server 2005 Express?
How do you know if SQL Server is running on your local system?
What is the simplest way to create a new database in MS SQL Server?
What is a database in MS SQL Server?
How to delete database objects with "DROP" statements in MS SQL Server?
How to delete a database in MS SQL Server?
How to set the current database in MS SQL Server?
What Are Exact Numeric Data Types in MS SQL Server?
How To Use GO Command in "sqlcmd"?
Why I am getting this error when dropping a database in MS SQL Server?
What Are Unicode Character String Data Types in MS SQL Server?
What Are Character String Data Types in MS SQL Server?
What Are Exact Numeric Data Types in MS SQL Server?
What Is Transact-SQL Language?
How To Count Duplicated Values in a Column in MS SQL Server?
What Are the Differences between CHAR and NCHAR in MS SQL Server?
What Are the Differences between CHAR and VARCHAR in MS SQL Server?
What Is a Constant or Literal in MS SQL Server?
Does Index Speed Up SELECT Statements?
How To Use "BEGIN ... END" Statement Structures in MS SQL Server?
How To Convert Numeric Values to Integers in MS SQL Server?
How To Convert Character Strings into Numeric Values?
What Is a Collation in MS SQL Server?
How to download Microsoft SQL Server 2005 Express Edition?
How To List All Schemas in a Database?
How To Transfer an Existing Table from One Schema to Another Schema in MS SQL Server?
Who Is the Owner of a Schema in MS SQL Server?
How To Test a DML Trigger in MS SQL Server?
How To Modify Existing Triggers using "ALTER TRIGGER"?
How To See the Event List of an Existing Trigger using sys.trigger_events?
What is Microsoft SQL Server?
How To Declare a Cursor with "DECLARE ... CURSOR" in MS SQL Server?
How To Create a New Login Name in MS SQL Server?
What Happens If NULL Values Are Involved in String Operations?
How To Declare and Use Cursor Variables?
How To Transfer Data from a Cursor to Variables with a "FETCH" Statement?
How To Write a Query with a Full Outer Join in MS SQL Server?
How To Insert a New Row into a Table with "INSERT INTO" Statements in MS SQL Server?
How to rename an existing column with SQL Server Management Studio?
What is Sql server?
What are the System Database in Sql server 2005?
What is the difference between SET and SELECT?
What is the difference between char , varchar and nvarchar?
How many types of triggers are there?
Which TCP/IP port does SQL Server run on? How can it be changed?
What are the System Database in Sql server 2008?
What are different types of normalization
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
What is Public Role in SQL Server?
Can SQL Servers linked to other servers like Oracle?
What is denormalization and when would you go for it?
What are the different types of Sub-Queries?
What are constraints? Explain different types of constraints?
What is the STUFF function and how does it differ from the REPLACE function?
Which command using Query Analyzer will give you the version of SQL server and operating system?
What are the different types of BACKUPs avaialabe in SQL Server 2005?
What is SQL Server Agent?
Name 3 ways to get an accurate count of the number of records in a table?
Define Primary Key?
What is cursors? and what are the different types of cursor?
Explain SQL Server Management Studio (SSMS)?
