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
- 5628 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 to check last update on table in db2?
What parameters are used to control the free space in DB2?
can we view the access paths created by dbrm ? how ? thx
What is the latest version of ibm db2?
What is a plan and package in db2?
What are the uses of db2 optimizer?
How is deadlock resolved?
What is difference between isnull and coalesce?
What is page size in db2?
Why select is not preferred in embedded sql programs?
What is the clustering index in the db2 database?
What is the role of data manager in the db2 database?
How to resolve deadlock issue
How to access db2 tables in mainframe?
How can record locking be achieved in those DB2 versions which do not support it?
