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

What are the benefits of using the db2 database?

0 Answers  

i want to delete 20th million record how ?

4 Answers   IBM,

What is the difference between drop table and delete table?

0 Answers  

when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic

2 Answers   TCS,

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

What is the difference between group by and order by?

2 Answers   IBM, TCS,

What is -904 sql code? How to resolve it?

3 Answers  

How do you simulate the EXPLAIN of an embedded SQL statement in SPUFI/QMF? Give an example with a host variable in WHERE clause)

2 Answers  

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

3 Answers   Zensar,

The only place of VSAM KSDS in DB2 is?

2 Answers   IBM,

cursor with hold explain ?

1 Answers   Verizon,

How would you find out the total number of rows in a db2 table?

0 Answers  

For more DB2 Interview Questions Click Here
Categories