Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Language Reference
Transact-SQL Reference
Transact-SQL Syntax Conventions (Transact-SQL)
What's New and Enhanced in Transact-SQL (Transact-SQL)
+ (Add) (Transact-SQL)
+ (Unary Plus) (Transact-SQL)
+ (String Concatenation) (Transact-SQL)
- (Negative) (Transact-SQL)
- (Subtract) (Transact-SQL)
* (Multiply) (Transact-SQL)
/ (Divide) (Transact-SQL)
% (Modulo) (Transact-SQL)
% (Wildcard - Character(s) to Match) (Transact-SQL)
& (Bitwise AND) (Transact-SQL)
| (Bitwise OR) (Transact-SQL)
^ (Bitwise Exclusive OR) (Transact-SQL)
~ (Bitwise NOT) (Transact-SQL)
= (Equals) (Transact-SQL)
> (Greater Than) (Transact-SQL)
< (Less Than) (Transact-SQL)
>= (Greater Than or Equal To) (Transact-SQL)
<= (Less Than or Equal To) (Transact-SQL)
<> (Not Equal To) (Transact-SQL)
!< (Not Less Than) (Transact-SQL)
!= (Not Equal To) (Transact-SQL)
!> (Not Greater Than) (Transact-SQL)
-- (Comment) (Transact-SQL)
/*...*/ (Comment) (Transact-SQL)
[ ] (Wildcard - Character(s) to Match) (Transact-SQL)
[^] (Wildcard - Character(s) Not to Match) (Transact-SQL)
_ (Wildcard - Match One Character) (Transact-SQL)
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQL)
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
ALTER APPLICATION ROLE (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)
ALTER ASYMMETRIC KEY (Transact-SQL)
ALTER AUTHORIZATION (Transact-SQL)
ALTER CERTIFICATE (Transact-SQL)
ALTER CREDENTIAL (Transact-SQL)
ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
ALTER FUNCTION (Transact-SQL)
ALTER INDEX (Transact-SQL)
ALTER LOGIN (Transact-SQL)
ALTER MASTER KEY (Transact-SQL)
ALTER MESSAGE TYPE (Transact-SQL)
ALTER PARTITION FUNCTION (Transact-SQL)
ALTER PARTITION SCHEME (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)
ALTER QUEUE (Transact-SQL)
ALTER REMOTE SERVICE BINDING (Transact-SQL)
ALTER ROLE (Transact-SQL)
ALTER ROUTE (Transact-SQL)
ALTER SCHEMA (Transact-SQL)
ALTER SERVICE (Transact-SQL)
ALTER SERVICE MASTER KEY (Transact-SQL)
ALTER SYMMETRIC KEY (Transact-SQL)
ALTER TABLE (Transact-SQL)
ALTER TRIGGER (Transact-SQL)
ALTER USER (Transact-SQL)
ALTER VIEW (Transact-SQL)
ALTER XML SCHEMA COLLECTION (Transact-SQL)
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)
AsymKey_ID (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-SQL)
BACKUP MASTER KEY (Transact-SQL)
BACKUP SERVICE MASTER KEY (Transact-SQL)
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Transact-SQL)
BEGIN DIALOG CONVERSATION (Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)
BEGIN TRANSACTION (Transact-SQL)
BETWEEN (Transact-SQL)
binary and varbinary (Transact-SQL)
BINARY_CHECKSUM
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST and CONVERT (Transact-SQL)
CATCH (TRY...CATCH) (Transact-SQL)
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
char and varchar (Transact-SQL)
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG (Transact-SQL)
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL)
CLOSE SYMMETRIC KEY (Transact-SQL)
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-SQL)
COMMIT WORK (Transact-SQL)
COMPUTE (Transact-SQL)
Constants (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
CONTINUE (Transact-SQL)
Control-of-Flow Language (Transact-SQL)
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
CREATE AGGREGATE (Transact-SQL)
CREATE APPLICATION ROLE (Transact-SQL)
CREATE ASSEMBLY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE CONTRACT (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
CREATE DATABASE (Transact-SQL)
CREATE DEFAULT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)
CREATE EVENT NOTIFICATION (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
CREATE FUNCTION (Transact-SQL)
CREATE INDEX (Transact-SQL)
CREATE LOGIN (Transact-SQL)
CREATE MASTER KEY (Transact-SQL)
CREATE MESSAGE TYPE (Transact-SQL)
CREATE PARTITION FUNCTION (Transact-SQL)
CREATE PARTITION SCHEME (Transact-SQL)
CREATE PROCEDURE (Transact-SQL)
CREATE QUEUE (Transact-SQL)
CREATE REMOTE SERVICE BINDING (Transact-SQL)
CREATE ROLE (Transact-SQL)
CREATE ROUTE (Transact-SQL)
CREATE RULE (Transact-SQL)
CREATE SCHEMA (Transact-SQL)
CREATE SERVICE (Transact-SQL)
CREATE STATISTICS (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE SYNONYM (Transact-SQL)
CREATE TABLE (Transact-SQL)
CREATE TRIGGER (Transact-SQL)
CREATE TYPE (Transact-SQL)
CREATE USER (Transact-SQL)
CREATE VIEW (Transact-SQL)
CREATE XML SCHEMA COLLECTION (Transact-SQL)
CURRENT_REQUEST_ID (Transact-SQL)
CURRENT_TIMESTAMP (Transact-SQL)
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursors (Transact-SQL)
DATABASEPROPERTY (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL)
Data Types (Transact-SQL)
DATALENGTH (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
Date and Time (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal and numeric (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
DECLARE CURSOR (Transact-SQL)
DecryptByAsymKey (Transact-SQL)
DecryptByCert (Transact-SQL)
DecryptByKey (Transact-SQL)
DecryptByKeyAutoAsymKey (Transact-SQL)
DecryptByKeyAutoCert (Transact-SQL)
DecryptByPassPhrase (Transact-SQL)
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP AGGREGATE (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
DROP CERTIFICATE (Transact-SQL)
DROP CONTRACT (Transact-SQL)
DROP CREDENTIAL (Transact-SQL)
DROP DATABASE (Transact-SQL)
DROP DEFAULT (Transact-SQL)
DROP ENDPOINT (Transact-SQL)
DROP EVENT NOTIFICATION (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
DROP FUNCTION (Transact-SQL)
DROP INDEX (Transact-SQL)
DROP LOGIN (Transact-SQL)
DROP MASTER KEY (Transact-SQL)
DROP MESSAGE TYPE (Transact-SQL)
DROP PARTITION FUNCTION (Transact-SQL)
DROP PARTITION SCHEME (Transact-SQL)
DROP PROCEDURE (Transact-SQL)
DROP QUEUE (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)
DROP ROLE (Transact-SQL)
DROP ROUTE (Transact-SQL)
DROP RULE (Transact-SQL)
DROP SCHEMA (Transact-SQL)
DROP SERVICE (Transact-SQL)
DROP SIGNATURE (Transact-SQL)
DROP STATISTICS (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
DROP SYNONYM (Transact-SQL)
DROP TABLE (Transact-SQL)
DROP TRIGGER (Transact-SQL)
DROP TYPE (Transact-SQL)
DROP USER (Transact-SQL)
DROP VIEW (Transact-SQL)
DROP XML SCHEMA COLLECTION (Transact-SQL)
DUMP (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL)
ENABLE TRIGGER (Transact-SQL)
EncryptByAsymKey (Transact-SQL)
EncryptByCert (Transact-SQL)
EncryptByKey (Transact-SQL)
EncryptByPassPhrase (Transact-SQL)
END (BEGIN...END) (Transact-SQL)
END CONVERSATION (Transact-SQL)
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT and INTERSECT (Transact-SQL)
EXECUTE AS (Transact-SQL)
EXECUTE AS Clause (Transact-SQL)
EXECUTE (Transact-SQL)
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Expressions (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQL)
FILEPROPERTY (Transact-SQL)
float and real (Transact-SQL)
FLOOR (Transact-SQL)
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQL)
fn_listextendedproperty (Transact-SQL)
fn_my_permissions (Transact-SQL)
fn_servershareddrives (Transact-SQL)
fn_trace_geteventinfo (Transact-SQL)
fn_trace_getfilterinfo (Transact-SQL)
fn_trace_getinfo (Transact-SQL)
fn_trace_gettable (Transact-SQL)
fn_virtualfilestats (Transact-SQL)
fn_virtualservernodes (Transact-SQL)
FOR Clause (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
Functions (Transact-SQL)
GET CONVERSATION GROUP (Transact-SQL)
GET_TRANSMISSION_STATUS (Transact-SQL)
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
Has_Perms_By_Name (Transact-SQL)
HashBytes (Transact-SQL)
HAVING (Transact-SQL)
Hints (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (Function) (Transact-SQL)
IDENTITY (Property) (Transact-SQL)
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQL)
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint, and tinyint (Transact-SQL)
INTO Clause (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL)
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOAD (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money and smallmoney (Transact-SQL)
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQL)
NCHAR (Transact-SQL)
nchar and nvarchar (Transact-SQL)
NEWID (Transact-SQL)
NEWSEQUENTIALID()
NOT (Transact-SQL)
ntext, text, and image (Transact-SQL)
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQL)
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-SQL)
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-SQL)
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operators (Transact-SQL)
OPTION Clause (Transact-SQL)
OR (Transact-SQL)
ORDER BY Clause (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)
OUTPUT Clause (Transact-SQL)
OVER Clause (Transact-SQL)
PARSENAME (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicate (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR (Transact-SQL)
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Reserved Keywords (Transact-SQL)
RESTORE Statements for Restoring, Recovering, and Managing Backups
RESTORE MASTER KEY (Transact-SQL)
RESTORE SERVICE MASTER KEY (Transact-SQL)
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact-SQL)
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
ROW_NUMBER (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL)
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Search Condition (Transact-SQL)
SELECT @local_variable (Transact-SQL)
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact-SQL)
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact-SQL)
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
System Stored Procedures (Transact-SQL)
System Tables (Transact-SQL)
System Views (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL)
sys.fn_translate_permissions (Transact-SQL)
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
TAN (Transact-SQL)
TERTIARY_WEIGHTS
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
timestamp (Transact-SQL)
tinyint (Transact-SQL)
TOP (Transact-SQL)
Trace Flags (Transact-SQL)
Transactions (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL)
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQL)
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-SQL)
VerifySignedByAsmKey (Transact-SQL)
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression (Transact-SQL)
WITH XMLNAMESPACES (Transact-SQL)
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact-SQL)
YEAR (Transact-SQL)
Expand Minimize
1 out of 1 rated this helpful - Rate this topic

sys.login_token (Transact-SQL)

SQL Server 2005

Updated: 12 December 2006

Returns one row for every server principal that is part of the login token.

Column name Data type Description

principal_id

int

ID of the principal. This value is unique within server.

sid

varbinary(85)

Security identifier of the principal. If this is a Windows principal, sid = Windows SID. If the login is mapped to a certificate, sid = GUID from the certificate.

name

nvarchar(128)

Name of the principal. This value is unique within server.

type

nvarchar(128)

Description of principal type. All types are mapped to sid. The value can be one of the following:

  • SQL LOGIN
  • WINDOWS LOGIN
  • WINDOWS GROUP
  • SERVER ROLE
  • LOGIN MAPPED TO CERTIFICATE
  • LOGIN MAPPED TO ASYMMETRIC KEY
  • CERTIFICATE
  • ASYMMETRIC KEY

usage

nvarchar(128)

Indicates the principal participates in the evaluation of GRANT or DENY permissions, or serves as an authenticator.

This value can be one of the following:

  • GRANT OR DENY
  • DENY ONLY
  • AUTHENTICATOR

Release History

12 December 2006

Changed content:
  • Added note about mapping type to sid.

17 July 2006

Changed content:
  • Corrected names of principals.
  • Corrected details of principals' significance in permissions evaluation.

5 December 2005

Changed content:
  • Changed column name sid_id to sid.
  • Corrected the size of the nvarchar columns.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.