Open topic with navigation
Contains information about privileges for users and tables in your database.
|Field||Type||Description||Associated Privileges||WITH GRANT OPTION included|
Indicates the type of the owner of this privilege:
Typically this is 3 or 4 for user or role.
|HOLDERSCHEMA||varchar(128)||Null for user holders, but role holders will be associated with a schema.|
|HOLDERNAME||varchar(128)||The name of the owner of this privilege. For example, if the owner type is user, this is the user name.|
Indicates the type of the object on which the privilege is placed.
|OBJECTSCHEMA||varchar(128)||Name of schema owning the object to which the privilege is granted.|
|OBJECTNAME||varchar(128)||Name of object to which the privilege is granted.|
Specifies the privilege granted to the object specified by
PRIVILEGES..PRIMARY_KEY on fields:
OBJECT_PRIVILEGES on fields: