15.10 - AccessLogV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Security

DBC

 

View Column

Data Type

Format

Source Table.Column

LogDate

DATE

NOT NULL

YY/MM/DD (explicit)

AccLogTbl.TheDate

LogTime

TIME

NOT NULL

99:99:99 (explicit)

AccLogTbl.TheTime

LogonDate

DATE

NOT NULL

YY/MM/DD (explicit)

AccLogTbl.LogonDate (NUPI)

LogonTime

TIME

NOT NULL

99:99:99 (explicit)

AccLogTbl.LogonTime (NUPI)

LogicalHostId

SMALLINT

NOT NULL

ZZZ9 (explicit)

AccLogTbl.LogicalHostId

IFPNo

SMALLINT

NOT NULL

-(5)9

AccLogTbl.IFPNo

SessionNo

INTEGER

NOT NULL

--,---,---,--9 (explicit)

AccLogTbl.SessionNo

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.UserName

AccountName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.AccountName

OwnerName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

AccLogTbl.OwnerName

AccessType

CHAR(2) LATIN

NOT CASESPECIFIC

NOT NULL

X(2)

AccLogTbl.AccessType

Frequency

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

AccLogTbl.Frequency

EventCount

INTEGER

--,---,---,--9 (explicit)

AccLogTbl.EventCount

AccLogResult

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

AccLogTbl.AccLogResult

DatabaseName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

AccLogTbl.DatabaseName

TVMName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

AccLogTbl.TVMName

ColumnName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

AccLogTbl.ColumnName

StatementType

VARCHAR(20) LATIN

NOT CASESPECIFIC

NOT NULL

X(20)

AccLogTbl.StatementType

StatementText

VARCHAR(8192)

UNICODE

NOT CASESPECIFIC

X(8192)

AccLogTbl.StatementText

QueryBand

VARCHAR(6160)

UNICODE

NOT CASESPECIFIC

X(6160)

AccLogTbl.Queryband

ProxyUser

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

AccLogTbl.ProxyUser

ConstraintId

BYTE(4)

X(8)

AcclogTbl.ConstraintId

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” on page 44).

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

UserName

The user name column is the name or profile of a user.

The following SELECT retrieves the name of the submitting user from the AccessLogV view, the type of request, and the request text of each request that caused a privilege check to be logged on a specific date. The response shows that one request caused a privilege check to be logged on that date. (The statement text column has been truncated in the results.)

==> SELECT LogDate, UserName, AccessType, StatementText FROM DBC.AccessLogV WHERE LogDate = 890510;

Result:

LogDate   UserName  AccessType  StatementText
--------  --------  ----------  ------------------------------
89/05/10  Jones     CT          CREATE TABLE Jones.EmpDup (Em