All databases
sysroles maps server role IDs to local role IDs.
The columns for sysroles are:
Name |
Datatype |
Description |
|---|---|---|
id |
int |
Server role ID (srid) |
lrid |
int |
Local role ID |
type |
smallint |
Unused |
status |
int |
Unused |
When a database permission is granted to a role, if an entry for the role does not exist in sysroles, Adaptive Server adds an entry to sysroles to map the local role ID (lrid) to the server-wide role ID (srid) in syssrvroles.
Unique clustered index on lrid
