|
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.
|
|
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 U (User) or G (Group).
|
|
PRIVILEGE_NAME
|
VARCHAR(20)
|
Specifies the privilege
name as one of the following values:
SELECT
UPDATE
INSERT
DELETE
EXECUTE
REFERENCES
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE VIEW
ALTER VIEW
DROP VIEW
CREATE CACHE
ALTER CACHE
|
|
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).
|
|
PREDICATE
|
VARCHAR(128)
|
Portion of the row-level security (RLS) predicate. The predicate might spawn multiple rows; is nullable.
|
|
PREDICATE_SEQUENCE
|
SMALLINT
|
specifies the sequence number of the portion of the RLS predicate; is nullable.
|
|
PRIV_ID
|
BIGINT
|
Privilege identifier.
|