Applies to all databases. sysroles maps server role IDs to local role IDs.
When a database permission is granted to a role, if an entry for the role does not exist in sysroles, the SAP ASE server adds an entry to sysroles to map the local role ID (lrid) to the server-wide role ID (srid) in syssrvroles.
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 |
Unique clustered index on lrid