Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: 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

  2. #2
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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

  3. #3
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    according the doc
    Authorization
    One of the following:
    * sysadm
    * sysctrl
    * sysmaint
    * sysmon
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  4. #4
    Join Date
    Oct 2004
    Location
    DELHI INDIA
    Posts
    338
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •