Previous Topic: Authority Required to Generate Table ProceduresNext Topic: Authorities to Add COBOL Source to the Dictionary

Table Procedure Examples, Design, and Use › Authority Required to Generate Table Procedures › Authorities to Obtain and Update Dictionary Records

Authorities to Obtain and Update Dictionary Records

Quick Bridge uses SQL queries to obtain and modify information in the dictionary. The following tables summarize the authorizations required to perform OBTAIN and UPDATE operations on dictionary records:

 

GRANT TABLE Privilege

Table Name

SELECT

INSERT

DELETE

SYSTEM.TABLE

X

 

 

SYSDICT."MODULE-067"

X

 

 

SYSDICT."OOAK-012"

X

 

 

SYSDICT."S-010"

X

 

 

SYSDICT."SS-026"

X

 

 

SYSDICT."SSR-032"

X

 

 

SYSDICT."RCDSYN-079"

X

 

 

SYSDICT."NAMESYN-083"

X

 

 

SYSDICT."SDR-042"

X

 

 

SYSDICT."ELEMSYN-085"

X

 

 

SYSDICT."SSMR-068"

X

 

 

SYSDICT."SSOR-034"

X

 

 

SYSDICT."SSCR-070"

X

 

 

SYSDICT."SR-036"

X

 

 

SYSDICT."SRCD-113"

X

 

 

CAAV.GETREC

X

 

 

CAAV.MODULETEXT

 

X

X