Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
GUID: DBSCHEMA_USAGE_PRIVILEGES
Number of restriction columns: 6
Restriction columns: OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, GRANTOR, GRANTEE
Default sort order: OBJECT_CATALOG, OBJECT_SCHEMA, OBJECT_NAME, OBJECT_TYPE, PRIVILEGE_TYPE
Description: The USAGE_PRIVILEGES rowset identifies the USAGE privileges on objects defined in the catalog that are available to or granted by a given user.
Column name |
Type indicator |
Description |
|---|---|---|
GRANTOR |
DBTYPE_WSTR |
User who granted the privileges on the object in OBJECT_NAME. |
GRANTEE |
DBTYPE_WSTR |
User name (or "PUBLIC") to whom the privilege has been granted. |
OBJECT_CATALOG |
DBTYPE_WSTR |
Catalog name in which the object is defined. NULL if the provider does not support catalogs. |
OBJECT_SCHEMA |
DBTYPE_WSTR |
Unqualified schema name in which the object is defined. NULL if the provider does not support schemas. |
OBJECT_NAME |
DBTYPE_WSTR |
Object name. |
OBJECT_TYPE |
DBTYPE_WSTR |
Object type. One of the following:
|
PRIVILEGE_TYPE |
DBTYPE_WSTR |
Privilege type. One of the following: "USAGE" |
IS_GRANTABLE |
DBTYPE_BOOL |
VARIANT_TRUE ? The privilege being described was granted with the WITH GRANT OPTION clause. VARIANT_FALSE ? The privilege being described was not granted with the WITH GRANT OPTION clause. |