Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

Where would you find information about the type of database
authority held by the user?

Question Posted / guest

Answers were Sorted based on User's Feedback



Where would you find information about the type of database authority held by the user?..

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

Where would you find information about the type of database authority held by the user?..

Answer / s

SYSIBM.SYSUSERAUTH

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More DB2 Interview Questions

How can you display the current date & current time ?

1 Answers   Cap Gemini,

could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..

5 Answers  

What is Declaration Generator(DCLGEN)?

1 Answers  

What is database manager in db2?

0 Answers  

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

0 Answers  

What is meant by a unit of recovery?

1 Answers  

Are views updateable?

0 Answers  

How to fetch the last row from the table in SQL (db2)?

0 Answers  

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

Is db2 a mainframe database?

0 Answers  

What are the uses of db2 optimizer?

0 Answers  

How can you find out the # of rows updated after an update statement?

0 Answers  

For more DB2 Interview Questions Click Here
Categories