Column Privileges Schema Rowset
Default Sort Order |
Supported Restrictions |
Supported Columns |
TABLE_SCHEMA TABLE_NAME COLUMN_NAME COLUMN_GUID COLUMN_PROPID PRIVILEGE_TYPE |
TABLE_SCHEMA TABLE_NAME COLUMN_NAME GRANTOR GRANTEE |
GRANTOR GRANTEE TABLE_SCHEMA TABLE_NAME COLUMN_NAME PRIVILEGE_TYPE IS_GRANTABLE |
Programming Considerations
If a privilege applies to all columns of a table, then OLE DB Provider for Teradata returns the name “ALL” as the COLUMN_NAME.
Privilege Types
The types returned in the PRIVILEGE_TYPE column can consist of the following:
For more information, refer to Chapter 2 of SQL Data Definition Language.