Results 1 to 2 of 2
  1. #1
    Join Date
    May 2007

    Unanswered: get snapshot authorization

    I am running DB2 v8.2.9 and AIX 5.3, I have a user, who is DBADM in a database, that is trying to issue the command "db2 get snapshots for locks on db ... " and he is getting SQL error due to lack of authorization.

    He was able to perform this, using a shell script, in our old environment which was DB2 v7.1.0 / AIX 4.3 under a different user id. So in the new environment I granted his user id exactly the same as the old one, but he still has problems. I tried to find in DB2 manuals the level of authorization necessary for get snapshot command but I couldn't find anything there. Since I am DBA (SYSADM) I don't problems with authorization.

    What can I do?


  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Don't know what kind of DB2 manuals you were looking at. Mine says

    One of the following:

    * sysadm
    * sysctrl
    * sysmaint
    * sysmon
    "It does not work" is not a valid problem statement.

Posting Permissions

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