All databases
sysprotects contains information on permissions that have been granted to, or revoked from, users, groups, and roles.
The columns for sysprotects are:
Name |
Datatype |
Description |
Name |
---|---|---|---|
id |
int |
ID of the object to which this permission applies. |
|
uid |
int |
ID of the user, group, or role to which this permission applies. |
|
action |
smallint |
One of the following permissions: |
|
|
|
||
protecttype |
tinyint |
One of the following values:
|
|
columns |
varbinary(133) |
Bitmap of columns to which this select, update , or references permission applies. The bits indicate the following:
columns is also a bitmap of permitted roles for set session authorization. |
|
grantor |
int |
User ID of the grantor. If the grantor is a System Administrator, the user ID of the object owner is used. |
Unique clustered index on id, action, grantor, uid, protecttype
Copyright © 2005. Sybase Inc. All rights reserved. |