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 |
Status bit that indicates whether the various server roles are set to their defaults at login:
|
|
Changing the status bit When you change the status bit using sp_modifylogin, you must log out and relog for the change to take effect. To see immediate results, use set role role_name off.
Clustered index on suid
