OBJECT_PRIVILEGES View

The OBJECT_PRIVILEGES view displays the privilege descriptors for all object-level privileges. All privileges for a single table can be obtained by concatenating rows matching the correct priv_id and ordering the results by sequence. The table below lists the columns that are associated with the OBJECT_PRIVILEGES view:
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.
Copyright © SAS Institute Inc. All rights reserved.