|
Name
|
Type
|
Description
|
|---|---|---|
|
CATALOG_NAME
|
VARCHAR(256)
|
Specifies the name of
the catalog.
|
|
SCHEMA_NAME
|
VARCHAR(256)
|
Specifies the name of
the schema.
|
|
OBJECT_NAME
|
VARCHAR(256)
|
Specifies the name of
the object.
|
|
COLUMN_NAME
|
VARCHAR(256)
|
Specifies the column
name.
|
|
GRANTOR
|
VARCHAR(256)
|
Specifies the user name
of the grantor.
|
|
GRANTOR_TYPE
|
CHAR(1)
|
Specifies the grantor type as U (User) or R (Role).
|
|
GRANTEE
|
VARCHAR(256)
|
Specifies the name of
the user who is granted privileges.
|
|
GRANTEE_TYPE
|
CHAR(1)
|
Specifies the grantee type as G (Group) or U (User).
|
|
PRIVILEGE_NAME
|
VARCHAR(20)
|
Specifies the privilege
name as one of the following values:
SELECT
UPDATE
INSERT
REFERENCES
|
|
PRIVILEGE_TYPE
|
VARCHAR(5)
|
Specifies the privilege type as GRANT or DENY.
|
|
GRANTABLE
|
CHAR(1)
|
Specifies if the privilege is grantable. The only valid value
is N (No).
|