sysloginroles

Applies to master database only. sysloginroles contains a row for each instance of a server login or login profile possessing a 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).

Note: When you change the status bit using alter login, you must log out and relog for the change to take effect. To see immediate results, use set role role_name off.

Columns

The columns for sysloginroles are:

Name Datatype Description

suid

int

Server user ID or login profile 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

  • 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
Status bit that indicates whether the various server roles are set to their defaults at login:

  • 0 = default off

  • 1 = default on
predid int

The object ID for the predicate of a grant role command. See Security Administration Guide > Predicated role activation.

Indexes

Clustered index on suid

Parent topic: System Tables