|
|
Archives of the TeradataForum
Message Posted: Wed, 13 Aug 2008 @ 11:13:39 GMT
Subj: | | Re: Access rights codes details |
|
From: | | Maken, Yasir Hassan |
Ritesh,
Here we go..
AE = ALTER EXTERNALPROCEDURE
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
I = INSERT
IX = INDEX
MR = MONITOR RESOURCE
MS = MONITOR SESSION
PC = CREATE PROCEDURE
PD = DROP PROCEDURE
PE = EXECUTE PROCEDURE
RO = REPLICATION OVERRIDE
R = RETRIEVE/SELECT
RF = REFERENCE
RS = RESTORE
SS = SET SESSION RATE
SR = SET RESOURCE RATE
U = UPDATE
UU = UDT Usage
UT = UDT Type
UM = UDT Method
Regards,
Yasir
| |