SQLTablePrivileges - ODBC Driver for Teradata - 16.20

ODBC Driver for Teradata® User Guide

prodname
ODBC Driver for Teradata
vrm_release
16.20
category
User Guide
featnum
B035-2526-108K

SQLTablePrivileges listed in the following table return all object-level privileges applicable to the specified tables or other database objects (macro, stored procedure, view, and so forth).

Privilege Name Purpose
ALTER EXTERNAL PROCEDURE Alter external procedure
ALTER FUNCTION Alter function
ANY PRIVILEGE All default privileges
ALTER PROCEDURE Alter procedure
CREATE EXTERNAL PROCEDURE Create an external procedure
CREATE FUNCTION Create function
CREATE OWNER PROCEDURE Create owner procedure
CREATE ROLE Create new user role
CRETRIG Create trigger
CHECKPT Checkpoint
CRESPROC Create procedure
DROP FUNCTION Drop function
DROPTBL Drop table
DROPTRIG Drop trigger
DROPSPROC Drop Procedure
DROPDB Drop database/user
DROPMAC Drop macro
DROPVW Drop view
EXECUTE FUNCTION Execute function
EXSPROC Execute procedure
OVERRIDE INSERT POLICY FOR CONSTRAINT Override insert policy for constraint
OVERRIDE UPDATE POLICY FOR CONSTRAINT Override update policy for constraint
OVERRIDE DELETE POLICY FOR CONSTRAINT Override delete policy for constraint
OVERRIDE SELECT POLICY FOR CONSTRAINT Override select policy for constraint
OVERRIDE DUMP OBJECT Override dump for object
OVERRIDE RESTORE OBJECT Override restore for object
REPOVRRIDE Replication Override
SHOW Access column data
STATISTICS Make table statistics
unknown New privilege to Teradata Database
and SELECT, INSERT, UPDATE, DELETE, GRANT, DUMP, EXECUTE, RESTORE, REFERENCES, and INDEX.