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 |
How will fetch last 5 rows from table in db2
How connect db2 database to datastage?
What are some SQL aggregates and other built-in functions?
Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Do we need cursor for Count(*)?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What is the latest version of ibm db2?
What is difference between alias and synonym in db2?
How to resolve -407 sql code in DB2?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What is the use of reorg in db2?