CATALOG_PRIVILEGES View

The CATALOG_PRIVILEGES view displays the catalog-level privileges for each catalog. The table below lists the columns that are associated with the CATALOG_PRIVILEGES view:
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).
Copyright © SAS Institute Inc. All rights reserved.