Where would you find information about the type of database
authority held by the user?
Answer Posted / sreesh
The informartion can be obtained from catalog table
SYSIB.SYSDBAUTH.
Following authories are kept on DB level in SYSIB.SYSDBAUTH.
1) CREATETABAUTH
2) CREATETSAUTH
3) DBADMAUTH
4) DBCTRLAUTH
5) DBMAINTAUTH
6) ISPLAYDBAUTH
7) LOADAUTH
8) REORGAUTH
9) RECOVERDBAUTH
10)REPAIRAUTH
11)STARTDBAUTH
12)STATSAUTH
13)STOPAUTH
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is reorg and runstats in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How will you return the number of records in table?
Give the name of some fields form sqlca.
What is meant by dclgen?
What is the max length of sqlca?
What is copy pending status in db2?
How to restart a DB2 program?
Explain about rct in db2?
Give a brief description of db2 isolation levels?
What is plan in cobol db2?
What is the use of commit in db2?
What is the use of dclgen in db2?
What is host variable?
Which component is responsible for processing sql statements and selecting access paths?