SCHEMA_PRIVILEGES View

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