Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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)
AS ABORT SESSION
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
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
G1 CREATE COMPUTE GROUP
G2 DROP COMPUTE GROUP
GC CREATE GLOP
GD DROP GLOP
GM GLOP MEMBER
HR HUT RELEASE LOCK * (*indicates a client system utility lock is involved, which may require a check for one or more privileges associated with DUMP and RESTORE.)
I INSERT
IX INDEX
M1 CREATE COMPUTE MAP
M2 DROP COMPUTE MAP
MR MONITOR RESOURCE
MS MONITOR SESSION
O1 CREATE COMPUTE PROFILE
O2 DROP COMPUTE PROFILE
OP CREATE OWNER PROCEDURE
PE EXECUTE PROCEDURE
RF REFERENCES
RS RESTORE
S RETRIEVE/SELECT
SR SET RESOURCE RATE
SS SET SESSION RATE
ST STATISTICS
U UPDATE
WL WRITE LOCK * (*indicates a locking object name FOR WRITE is involved, which may require checks for INSERT, UPDATE, 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.