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
- 5749 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
Explain about open switch business continuity software?
What are the benefits of using the db2 database?
What is explain plan in db2?
Mention the location where the output received from explain statement is stored.
Can one database have multiple instances?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is the default page size of buffer pools?
If I have a view which is a join of two or more tables, can this view be updateable?
How to check last update on table in db2?
Which component is responsible for db2 startup and shutdown?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
Can we insert update delete in view?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is an instance database?
What is access path in db2?
