15.10 - Access Rights Codes - Teradata Administrator

Teradata Administrator User Guide

prodname
Teradata Administrator
vrm_release
15.10
category
User Guide
featnum
B035-2502-035K

These access rights codes describe the user access privilege on a particular database, table, or column.

 

Table 42: Access Rights Codes 

Access Right Code

Description

AE

Alter External Procedure

AF

Alter Function

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 SET

GD

Drop GLOP SET

GM

GLOP Member

I

Insert

IX

Indexes

MR

Monitor Resource

MS

Monitor Session

NT

Non Temporal

OA

Override Archive Constraint

OD

Override Delete Constraint

OI

Override Insert Constraint

OP

Create Owner Procedure

OR

Override Restore Constraint

OS

Override Select Constraint

OU

Override Update Constraint

PC

Create Procedure

PD

Drop Procedure

PE

Execute Procedure

R

Retrieve or Select

RF

References

RS

Restore

SH

Show

SA

Constraint Assignment

SD

Constraint Definition

SS

Set Session Rate

SR

Set Resource Rate

ST

Statistics

TH

Connect Through

U

Update

UM

UDT Method

UT

UDT Type

UU

UDT Usage