Where would you find information about the type of database
authority held by the user?
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 I copy a table in db2?
What is scrollable cursor in db2?
What is buffer pool?
Is db2 a programming language?
Give the name of some fields form sqlca.
How to take backup of table in db2?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
How is deadlock resolved?
What is the syntax for creating a table in the db2 database?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
When the like statement is used?
What language is db2 written in?
How can we retrieve the total number of records in RPG & CLLE?
Are view updateable?