|
Name
|
Type
|
Description
|
|---|---|---|
|
CATALOG_NAME
|
VARCHAR(256)
|
The catalog name.
|
|
GRANTOR
|
VARCHAR(256)
|
The user name of the
grantor.
|
|
GRANTOR_TYPE
|
CHAR(1)
|
Specifies the grantor type as R (Role) or U (User).
|
|
GRANTEE
|
VARCHAR(256)
|
Specifies the user name
of the grantee.
|
|
GRANTEE_TYPE
|
CHAR(1)
|
Specifies the grantee type as G (Group) or U (User).
|
|
PRIVILEGE_NAME
|
VARCHAR(20)
|
Privilege name specified
as one of the following:
SELECT
UPDATE
INSERT
DELETE
EXECUTE
REFERENCES
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
can be granted to others. The only valid value is N (No).
|