Column Privileges Schema Rowset - OLE DB Provider for Teradata

OLE DB Provider for Teradata User Guide

Product
OLE DB Provider for Teradata
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2498
Product Category
Teradata Tools and Utilities

Column Privileges Schema Rowset

 

Table 27: 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:

  • CRESPROC     Create Stored Procedure
  • CRETRIG Create Trigger
  • CREVW          Create View
  • DELETE
  • DRROPTBL Drop Table
  • DROPSPROC    Drop Stored Procedure
  • DROPTRIG Drop Trigger
  • DROPVW        Drop View
  • DUMP
  • EXSPPOC         Execute Stored Procedure
  • INDEX
  • INSERT
  • REFERENCES
  • RESTORE
  • SELECT
  • UPDATE
  • For more information, refer to Chapter 2 of SQL Data Definition Language.