|
Name
|
Type
|
Description
|
|---|---|---|
|
CATALOG_NAME
|
VARCHAR(256)
|
Specifies the name of
the catalog.
If not applicable, the value is NULL.
|
|
SCHEMA_NAME
|
VARCHAR(256)
|
Specifies the name of
the schema.
|
|
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 TABLESPACE
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE VIEW
ALTER VIEW
DROP VIEW
CREATE CACHE
ALTER CACHE
CREATE TABLESPACE
|
|
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).
|