If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > list applicaiton what is minimum rights to get this data

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-15-09, 05:52
grofaty grofaty is offline
Registered User
 
Join Date: Jan 2003
Posts: 1,570
list applicaiton what is minimum rights to get this data

Hi,
on db2 v9.5 on Linux I have one user that only needs access to "list application" command. What is minimum rights I must give to this user? I don't want to give him any other rights except this one.
Regards
Reply With Quote
  #2 (permalink)  
Old 01-15-09, 06:41
JAYANTA_DATTA JAYANTA_DATTA is offline
Registered User
 
Join Date: Oct 2004
Location: DELHI INDIA
Posts: 336
He just need to have CONNECT Privilege to the Database inside the Instance. He needs to ATTACH to the particular instance and then submit the LIST APPLICATION command.
__________________

Jayanta Datta
DB2 UDB DBA
IBM India, Global Delivery
New Delhi
Reply With Quote
  #3 (permalink)  
Old 01-15-09, 07:15
przytula_guy przytula_guy is offline
Registered User
 
Join Date: Apr 2006
Location: Belgium
Posts: 1,159
according the doc
Authorization
One of the following:
* sysadm
* sysctrl
* sysmaint
* sysmon
__________________
Best Regards, Guy Przytula
Database Software Consultant
DB2 UDB LUW Certified V7-V8-V9-V9.7 DB Admin - Dprop..
Information Server Datastage Certified
http://www.infocura.be
Reply With Quote
  #4 (permalink)  
Old 01-15-09, 08:00
JAYANTA_DATTA JAYANTA_DATTA is offline
Registered User
 
Join Date: Oct 2004
Location: DELHI INDIA
Posts: 336
Quote:
Originally Posted by przytula_guy
according the doc
Authorization
One of the following:
* sysadm
* sysctrl
* sysmaint
* sysmon
my mistake. You are correct. the above authorization is more than sufficient for this. You don't even need to have DB CONNECT authority.
__________________

Jayanta Datta
DB2 UDB DBA
IBM India, Global Delivery
New Delhi
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On