SQLTablePrivileges - ODBC Driver for Teradata

ODBC Driver for Teradata® User Guide

Product
ODBC Driver for Teradata
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-08-22
dita:mapPath
xbl1544831938754.ditamap
dita:ditavalPath
nkw1500504256726.ditaval
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 the database
and SELECT, INSERT, UPDATE, DELETE, GRANT, DUMP, EXECUTE, RESTORE, REFERENCES, and INDEX.