DS_PRIVILEGES View

The DS_PRIVILEGES view displays the privilege descriptors for all data source-level privileges.

The table below lists the columns that are associated with the DS_PRIVILEGES view:

Name	Type	Description
DATA_SERVICE_NAME	VARCHAR(256)	Specifies the unique name of the data service.
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 user name of the grantee.
GRANTEE_TYPE	CHAR(1)	Specifies the grantee type as U (User) or G (Group).
PRIVILEGE_NAME	VARCHAR(20)	Indicates the name of privilege as reflected in the following list: SELECT UPDATE INSERT DELETE EXECUTE REFERENCES CREATE TABLE ALTER TABLE DROP TABLE CREATE VIEW ALTER VIEW DROP VIEW CREATE CACHE ALTER CACHE CREATE TABLESPACE If the value of DATA_SERVICE_NAME is _SERVER_, which corresponds to the SAS® Federation Server, the ADMINISTER and TRACE privileges can also be displayed. The ADMINISTER and TRACE privileges can be set on the SAS® Federation Server only.
PRIVILEGE_TYPE	VARCHAR(5)	Specifies the privilege type can be GRANT or DENY.
GRANTABLE	CHAR(1)	Specifies if the privilege is grantable. The only valid value is N (No).