Explanation on abbreviations used in TD Administrator

Tools & Utilities
Enthusiast

Explanation on abbreviations used in TD Administrator

The following are some of the abbreviations that i found under AccessRight in TD Administrator. Will someone please explain these or let me know where i can find explanations for all these?

U, RS, R, PE, PD, Pc and many more like these...

Thanks,
Varun
2 REPLIES
Enthusiast

Re: Explanation on abbreviations used in TD Administrator

From the data dictionary manual:

• 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
Enthusiast

Re: Explanation on abbreviations used in TD Administrator

Thank you Barry...that was quite comprehensive..

regards,
varun