Where would you find information about the type of database
authority held by the user?
- 2 Answers
- 5119 Views
- I also Faced
- E-Mail Answers
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 |
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What is an alias and how does it differ from a synonym?
What is the cascade rule and how does it relate to deletions made with a subselect?
What is query_cache_limit?
Where can you declare a cursor in a cobol-db2 program?
Mention the location where the output received from explain statement is stored.
how we will do null data selection in cobol-db2 program
What are the various data types available in db2?
What can the SET option of the Repair Utility accomplish?
What's the difference between DB2 active log and archive log? Thanks a lot...
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is meant by dclgen?
COBOL 
