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
- 5550 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
How do you pull up a query which was previously saved in qmf?
What is node in db2?
How do I delete a table in database?
What is the maximum size of varchar data type in db2?
What is the usage of open cursor command?
What is host variable in db2 cobol?
Discuss about db2 bind?
What is db2 command?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
How does coalesce work?
What's The Percentage Free Space ?
What is null value in db2?
Why do we use cursor?
What is role in db2?
