Where would you find information about the type of database
authority held by the user?
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 |
Is Cursor exicutable ?
When do you specify the isolation level?
how to u check the query is executing or not ?where will u check for sqlcode ?
What is a precompiler?
What will the COMMIT accomplish?
What is syscat in db2?
Explain db2.
What is with ur in db2?
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
What is the purpose of coding FETCH in a SQL SELECT query? Explain with an example in Detail?
Can you use a select query in a loop to fetch multiple rows? If so what is the advantage of using a cursor?
When Can you be sure that a query will return only one row?