Access privileges with detail information in Teradata

============================================================

Additional Privileges 

============================================================

The following privileges must be granted by DBC or another user who already has these privileges:

Table-Level Privileges

• INDEX

• REFERENCES

GLOP Data Privileges

• CREATE GLOP

Note: The creator and owner of a GLOP SET are automatically granted GLOP MEMBER and DROP GLOP privilege on the created GLOP set.

• DROP GLOP

• GLOP MEMBER

Monitor Privileges

• ABORTSESSION

• MONRESOURCE

• MONSESSION

• SETRESRATE

• SETSESSRATE

Row-level Security Override Privileges

• OVERRIDE INSERT CONSTRAINT

• OVERRIDE UPDATE CONSTRAINT

• OVERRIDE DELETE CONSTRAINT

• OVERRIDE SELECT CONSTRAINT

• OVERRIDE ARCHIVE CONSTRAINT

• OVERRIDE RESTORE CONSTRAINT

Note: The grantor of these privileges must have the system-level privilege CONSTRAINT ASSIGNMENT. These privileges cannot be granted with the WITH GRANT OPTION.

System-level Privileges

• CONSTRAINT DEFINITION

• CONSTRAINT ASSIGNMENT

• CREATE PROFILE

• CREATE ROLE

• DROP PROFILE

• DROP ROLE

• REPLCONTROL

• CTCONTROL

UDT privileges

• UDTMETHOD

• UDTUSAGE

• UDTTYPE

====================================================================== 

Description of Privileges
======================================================================

The AccessRight column of the following views:

• DBC.AllRightsV

• DBC.UserGrantedRightsV

• DBC.UserRightsV

• DBC.AllRoleRightsV

• DBC.UserRoleRightsV

Reports a two character code that represents a privilege granted on a particular object. The following list describes what privileges the codes represent:

• AE = ALTER EXTERNAL PROCEDURE

• AF = ALTER FUNCTION

• AP = ALTER PROCEDURE

• AS = ABORT SESSION

• CA = CREATE AUTHORIZATION

• CD = CREATE DATABASE

• CE = CREATE EXTERNAL PROCEDURE

• CF = CREATE FUNCTION

• CG = CREATE TRIGGER

• CM = CREATE MACRO

• CO = CREATE PROFILE

• CP = CHECKPOINT

• CR = CREATE ROLE

• CT = CREATE TABLE

• CU = CREATE USER

• CV = CREATE VIEW

• D = DELETE

• DA = DROP AUTHORIZATION

• DD = DROP DATABASE

• DF = DROP FUNCTION

• DG = DROP TRIGGER

• DM = DROP MACRO

• DO = DROP PROFILE

• DP = DUMP

• DR = DROP ROLE

• DT = DROP TABLE

• DU = DROP USER

• DV = DROP VIEW

• E = EXECUTE

• EF = EXECUTE FUNCTION

• GC = CREATE GLOP

• GD = DROP GLOP

• GM = GLOP MEMBER

• I = INSERT

• IX = INDEX

• MR = MONITOR RESOURCE

• MS = MONITOR SESSION

• NT = NONTEMPORAL

• OD = OVERRIDE DELETE POLICY (Reserved for future use)

• OI = OVERRIDE INSERT POLICY (Reserved for future use)

• OP = CREATE OWNER PROCEDURE

• OS = OVERRIDE SELECT POLICY (Reserved for future use)

• OU = OVERRIDE UPDATE POLICY (Reserved for future use)

• PC = CREATE PROCEDURE

• PD = DROP PROCEDURE

• PE = EXECUTE PROCEDURE

• R = RETRIEVE/SELECT

• RF = REFERENCE

• RO = REPLCONTROL

• RS = RESTORE

• SA = SECURITY CONSTRAINT ASSIGNMENT

• SD = SECURITY CONSTRAINT DEFINITION

• SH = SHOW

• SR = SET RESOURCE RATE

• SS = SET SESSION RATE

• ST = STATISTICS

• TH = CTCONTROL

• U = UPDATE

• UM = UDT Method

• UT = UDT Type

• UU = UDT Usage

To view the source code of an SQL UDF, you need one of the following privileges to execute the SHOW FUNCTION statement:

• Any privilege on the UDF or its containing database

• SELECT privileges on the DBC.TVM table

For information on the SHOW FUNCTION statement, see SQL Data Definition Language.