Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2006
    Posts
    31

    Unanswered: SQL1092N -"" does not have the authority to perform the requested command

    Hi All,
    We have DB2 v9.5 Fix Pack 5 on AIX 5.3. We created an ID for backup vendor commvault to perform backup/restore but restrict them from data in the user tables. Below is what I have done so far..
    created a group 'MAINT'
    created an ID 'comvault' and assigned to MAINT group
    updated dbm cfg using SYSMAINT MAINT
    updated environment variable DB2_ALTERNATE_GROUP_LOOKUP using GETGRSET
    recycled db2
    When I try to backup the db, I am getting the SQL1092N error.

    $ id
    uid=76226077(comvault) gid=1(staff) groups=207(MAINT)
    $ db2 backup db <dbname> online
    SQL1092N "COMVAULT" does not have the authority to perform the requested command.

    Any help is greatly appreciated.
    Thanks,
    Sam.

  2. #2
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Sam, there are 5 diff answers to your question. be specific on the error message. better yet, look up message description.
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Don't use uppercase group names.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Nov 2006
    Posts
    31
    Thanks Nick. Works great.

Posting Permissions

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