USAGE_PRIVILEGES
Records instances of privileges which grant the right to use a database object.
Column name
|
Data type
|
Description
|
OBJECT_SYSID
|
INTEGER
|
System identifier of the database object. |
OBJECT_PRIVILEGE
|
CHAR(20)
|
One of:
"DATABANK"
"BACKUP"
"SHADOW"
"IDENT"
"MEMBER"
"PROGRAM"
"TABLE"
"DOMAIN"
"MODULE"
"PROCEDURE"
"FUNCTION"
"SCHEMA"
"SEQUENCE"
"CHARACTER SET"
"COLLATION"
"TRANSLATION". |
GRANTEE
|
VARCHAR(128)
|
The name of the ident to whom the usage privilege was granted. |
GRANTOR
|
VARCHAR(128)
|
The name of the ident granting the usage privilege. |
IS_GRANTABLE
|
CHAR(3)
|
One of:
"YES" = WITH GRANT OPTION is held with the privilege
"NO" = WITH GRANT OPTION is not held with the privilege. |
Primary key: OBJECT_SYSID, OBJECT_PRIVILEGE, GRANTEE, GRANTOR
Secondary index: GRANTEE
Secondary index: GRANTOR
