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 the usage of open cursor command?
what is a corelated subquerry?
What is the physical storage length of timestamp data type?
What is db2 catalog database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is the use of with ur in db2?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
what is the role of the cursor in db2?
What is a plan and package in db2?
What is db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a db2 tablespace?
What are host variables in db2?
Can you use max on a char column?
Explain the function of data manager.