|
Name
|
Type
|
Description
|
|---|---|---|
|
DSN_NAME
|
VARCHAR(256)
|
Specifies the unique name of the DSN.
|
|
DATA_SERVICE
|
VARCHAR(256)
|
Specifies the name of
the data service.
|
|
GRANTOR_ID
|
VARCHAR(256)
|
Specifies the AuthID
of the user that granted or denied the privilege.
|
|
GRANTOR
|
VARCHAR(256)
|
Specifies the name of the user who is granted or denied the
privilege.
|
|
GRANTOR_TYPE
|
CHAR(1)
|
Specifies the grantor type as U (User) or R (Role).
|
|
GRANTEE_ID
|
VARCHAR(256)
|
Specifies the AuthID
of the user that is granted or denied the privilege.
|
|
GRANTEE
|
VARCHAR(256)
|
Specifies the name of the user who is granted or denied
the privilege.
|
|
GRANTEE_TYPE
|
CHAR(1)
|
Specifies the grantee type as U (User) or G (Group).
|
|
PRIVILEGE_NAME
|
VARCHAR(20)
|
Specifies the privilege
name:
SELECT
UPDATE
INSERT
DELETE
EXECUTE
REFERENCES
CREATE TABLE
ALTER TABLE
DROP TABLE
CREATE VIEW
ALTER VIEW
DROP VIEW
|
|
PRIVILEGE_TYPE
|
VARCHAR(5)
|
Specifies the privilege type as GRANT or DENY.
|
|
GRANTABLE
|
CHAR(1)
|
Specifies if the user
can grant this privilege to other users. The only valid value is N
(No).
|
|
INHERITED
|
CHAR(1)
|
Indicates whether the
privilege is inherited as either Y or N.
|
|
SOURCE_OBJECT_LEVEL
|
INTEGER
|
Specifies the object
level where the privilege is inherited, as one of the following values:
0 — Server
1 — Data service
2 — DSN
|
|
SOURCE_GRANTEE_ID
|
VARCHAR(256)
|
Specifies the AuthID
of a group or user from which the privilege is derived.
|
|
SOURCE_GRANTEE
|
VARCHAR(256)
|
Specifies the name of
the group or user from which the privilege is derived.
|
|
SOURCE_GRANTEE_TYPE
|
CHAR(1)
|
Specifies the source_grantee type U (User) or G (Group).
|