Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Aug 2008 @ 11:13:39 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023