master database only
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).
The columns for sysloginroles are:
Name |
Datatype |
Description |
|---|---|---|
suid |
int |
Server user ID |
srid |
int |
Server role ID; one of the following:
|
status |
smallint |
Reserved |
