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
- 5584 Views
- I also Faced
- E-Mail Answers
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
Mention data types used in db2 ?
What is difference between rollback and commit?
What is runstats utility in db2?
What are db2 tables?
What is buffer pool in the db2 database?
How is the value function used?
What is ibm db2 connect?
What is buffer pool?
What is null indicator in db2?
What is package in cobol db2?
What is the result of open cursor statement?
Define check constraint.
Why db2 is called db2?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
