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 to find last record before record through SQLRPGLE?

1 Answers   IBM,

What is a composite index and how does it differ from a multiple index?

1 Answers  

How would the varchar column remarks defined?

0 Answers  

Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  

What is a page?

2 Answers  

How do I delete a table in database?

0 Answers  

how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none

8 Answers   Amdocs, HeadStrong,

what's the best lock size that you could use when you create a tablespace?

2 Answers   IBM,

What is Skeleton cursor table (SKCT)?

2 Answers  

what is difference between random and sequence file access

1 Answers   Syntel,

What does the sqlcode of -818 pertain to?

3 Answers  

What language is db2 written in?

0 Answers  

For more DB2 Interview Questions Click Here
Categories