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
Copyright © 2005. Sybase Inc. All rights reserved. |