Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 20 May 2011 @ 21:09:28 GMT


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


Subj:   Re: Mysterious access rights
 
From:   Woodrow, Steven

     GC = Create Glop
     GM = Glop Member
     SH = Show
     ST = Statistics
     TH = CTCONTROL

I found these in the 13.0 Data Dictionary manual (B035-1092-098A)

     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(MACRO)
     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
     OI = OVERRIDE INSERT POLICY
     OP = CREATE OWNER PROCEDURE
     OS = OVERRIDE SELECT POLICY
     OU = OVERRIDE UPDATE POLICY
     PC = CREATE PROCEDURE
     PD = DROP
     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

Steve Woodrow
Global Support Center
Teradata
Customer Services



     
  <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: 27 Dec 2016