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

Can we use select * statement in cobol program without giving field names ???

3 Answers   Zensar,

What is phantom read in db2?

0 Answers  

What do you need to do before you do EXPLAIN?

1 Answers  

What do you mean by cursor?

0 Answers  

can i code union in cobol-db2 pgm ?

4 Answers   Patni,

how to u check the query is executing or not ?where will u check for sqlcode ?

6 Answers   Infosys,

what is db2 restart?

0 Answers  

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

What is a collection in db2?

0 Answers  

Can we install 2 different versions of Db2 on same mainframe?

3 Answers  

What is the purpose of the DSNC transaction ?

1 Answers  

What is DCLGEN?

2 Answers  

For more DB2 Interview Questions Click Here
Categories