Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.