|
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).
|