Interested to Buy Any Domain ? << Click Here >> for more details...
Where would you find information about the type of database
authority held by the user?
- 2 Answers
- 5632 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What are the prerogatives?
What is the role of the data page in the db2 database?
What will happen, while trying to close the closed cursor.
How do I delete a table in db2?
How many buffer pools are there in DB2?
Which component is responsible for db2 startup and shutdown?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
which authority can be granted to group of users using the GRANT stmt? A) SYSCTRL B) SYSADM C) DBCTRL D) DB ADM
how to resolve -818 error. how to see timestamp token in load module and plan
Explain about dbrm.
What action db2 takes when a program aborts in the middle of a transaction?
COBOL 
