Chapter 1: System Tables

sysloginroles

master database only

Description

sysloginroles contains a row for each instance of a server login possessing a system role. One row is added for each role granted to each login. For example, if a single server user is granted sa_role, sso_role, and oper_role, three rows are added to sysloginroles associated with that user’s system user ID (suid).

Columns

The columns for sysloginroles are:

Name	Datatype	Description
suid	int	Server user ID
srid	int	Server role ID; one of the following: 0 – sa_role 1 – sso_role 2 – oper_role 4 – navigator_role 5 – replication_role 6 – Currently unused 7 – dtm_tm_role 8 – ha_role 9 – Used internally 10 – mon_role 11 – js_admin_role 12 – messaging_role 13 – js_client_role 14 – js_user_role 15 – webservices_role
status	smallint	Reserved

Name

Datatype

Description

suid

int

Server user ID

srid

int

Server role ID; one of the following:

0 – sa_role
1 – sso_role
2 – oper_role
4 – navigator_role
5 – replication_role
6 – Currently unused
7 – dtm_tm_role
8 – ha_role
9 – Used internally
10 – mon_role
11 – js_admin_role
12 – messaging_role
13 – js_client_role
14 – js_user_role
15 – webservices_role

status

smallint

Reserved

Indexes

Clustered index on suid

View this book as PDF