17.00 - Usage Notes - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Each row displays the results of a privilege check. Whether a privilege check is logged depends on the presence and the criteria of an access logging rule (see AccLogRulesV).

Possible Values for AccessType

Value Description
AE ALTER EXTERNAL PROCEDURE
AF ALTER FUNCTION
AN ANY PRIVILEGE * h (*indicates a HELP or SHOW statement for which at least one privilege, but no specific privilege, is required)
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
HR HUT RELEASE LOCK * (*indicates a client system utility lock is involved, which could require a check for one or more privileges associated with DUMP and RESTORE.)
I INSERT
IX INDEX
MR MONITOR RESOURCE
MS MONITOR SESSION
OP CREATE OWNER PROCEDURE
PC CREATE PROCEDURE
PD DROP PROCEDURE
PE EXECUTE PROCEDURE
RF REFERENCES
RS RESTORE
S RETRIEVE/SELECT
SR SET RESOURCE RATE
SS SET SESSION RATE
ST STATISTICS
U UPDATE
UM UDT METHOD
UT UDT TYPE
UU UDT USAGE
WL WRITE LOCK * (*indicates a locking object name FOR WRITE is involved, which may require checks for INSERT, UPDATE, and/or DELETE privileges.)

Possible Values for AccLogResult

Value Description
G GRANTED
D DENIED
U U indicates that authorization is granted, but the access rights check was bypassed.