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 is a subselect? Is it different from a nested select?

1 Answers  

What are the advantages of using a PACKAGE?

2 Answers  

What are the levels of isolation available with DB2V4

2 Answers   IBM,

How do I delete a column in db2?

0 Answers  

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

Write a query to extract first 5 characters of a name in the column Stud_Name?

1 Answers   RBS,

What is access path in db2?

0 Answers  

What is cursor with hold option in db2?

0 Answers  

What does reorg do in db2?

0 Answers  

What are packages in db2?

0 Answers  

How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,

What is a system catalog table in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories