AccessRight Column

Value	Description
AE	ALTER EXTERNAL PROCEDURE
AF	ALTER FUNCTION
AP	ALTER PROCEDURE
AR	OVERRIDE RESTORE
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 (MACRO)
EF	EXECUTE FUNCTION
GC	CREATE GLOP
GD	DROP GLOP
GM	GLOP MEMBER
I	INSERT
IX	INDEX
MR	MONTIOR RESOURCE
MS	MONITOR SESSION
NT	NONTEMPORAL
OA	OVERRIDE DUMP
OD	OVERRIDE DELETE POLICY
OI	OVERRIDE INSERT POLICY
OP	CREATE OWNER PROCEDURE
OS	OVERRIDE SELECT POLICY
OU	OVERRIDE UPDATE POLICY
PC	CREATE PROCEDURE
PD	DROP PROCEDURE
PE	EXECUTE PROCEDURE
R	RETRIEVE/SELECT
RF	REFERENCE
RO	REPLCONTROL
RS	RESTORE
SA	SECURITY CONSTRAINT ASSIGNMENT (system wide)
SD	SECURITY CONSTRAINT DEFINITION (system wide)
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

DBC.logonoff : Event column

Account Name Column

The AccountName column is the current unexpanded account name for the session.

Possible Values for Event Column

•Logon

•Logoff

•Logon failed

This value means a logon failed for reasons other than “Bad User,” “Bad Account,” or “Bad Password.” Currently, those other reasons are a failure to conform to Logon Rules or an attempt to log on without a password, where the TDP logon exit does not approve the logon.

•Bad user

•Bad account

This value means the user provided an account string during logon time, but that string does not match any of the account names specified for the user in the SQL CREATE USER or MODIFY USER statement.

•Bad password

•Bad profile

The external profile associated with the logon request does not exist. External profiles are stored in the directory server.

•Forced off

This value indicates that the user session was terminated from the Teradata Database console or the PM/API.

•IP restriction

This value indicates the user is not permitted to log on from the IP address used.

•Authentication failed

•Bad authentication

This value may indicate other authentication errors: bad authentication field, deprecated logons, decryption failure, and so forth.

UserName Column

The UserName column returns “Non-existent User” when a user tries to log on with a bad username.