Thursday, October 18, 2012

List of Teradata Database Access Rights


Here is list of access right and their full-form.

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
GD = DROP GLOP
GM = GLOP MEMBER
I = INSERT
IX = INDEX
MR = MONITOR RESOURCE
MS = MONITOR SESSION
NT = NONTEMPORAL
OD = OVERRIDE DELETE POLICY (Reserved for future use)
OI = OVERRIDE INSERT POLICY (Reserved for future use)
OP = CREATE OWNER PROCEDURE
OS = OVERRIDE SELECT POLICY (Reserved for future use)
OU = OVERRIDE UPDATE POLICY (Reserved for future use)
PC = CREATE PROCEDURE
PD = DROP PROCEDURE
PE = EXECUTE PROCEDURE
R = RETRIEVE/SELECT
RF = REFERENCE
RO = REPLCONTROL
RS = RESTORE
SA = SECURITY CONSTRAINT ASSIGNMENT
SD = SECURITY CONSTRAINT DEFINITION
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

No comments:

Post a Comment