Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2011
    Posts
    26

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

    I am not able to create or drop database, but i can stop and start db2 instance.

    User is a domain user, but memeber of local Administrator group and
    DB2ADMNS local group which is SYSADM_GROUP in dbm cfg.
    OS windows XP.

    i tried setting DB2_GRP_LOOKUP=LOCAL or
    DB2_GRP_LOOKUP=LOCAL,TOKENLOCAL , but no use.

    Any suggestions.

  2. #2
    Join Date
    Apr 2008
    Posts
    39
    To drop a db user should have either sysadm or sysctrl Authorization. Please check what type of Authorization your user id had.

    Thanks
    Naval K

  3. #3
    Join Date
    Oct 2007
    Posts
    246
    paste the output of

    db2 get authorizations

    regds
    Paul

  4. #4
    Join Date
    Sep 2011
    Posts
    26

    It Works now

    Hi i am not sure what i did , but now it is fine.

    U:\>db2 get authorizations

    Administrative Authorizations for Current User

    Direct SYSADM authority = NO
    Direct SYSCTRL authority = NO
    Direct SYSMAINT authority = NO
    Direct DBADM authority = NO
    Direct CREATETAB authority = NO
    Direct BINDADD authority = NO
    Direct CONNECT authority = NO
    Direct CREATE_NOT_FENC authority = NO
    Direct IMPLICIT_SCHEMA authority = NO
    Direct LOAD authority = NO
    Direct QUIESCE_CONNECT authority = NO
    Direct CREATE_EXTERNAL_ROUTINE authority = NO
    Direct SYSMON authority = NO

    Indirect SYSADM authority = YES
    Indirect SYSCTRL authority = NO
    Indirect SYSMAINT authority = NO
    Indirect DBADM authority = NO
    Indirect CREATETAB authority = YES
    Indirect BINDADD authority = YES
    Indirect CONNECT authority = YES
    Indirect CREATE_NOT_FENC authority = NO
    Indirect IMPLICIT_SCHEMA authority = YES
    Indirect LOAD authority = NO
    Indirect QUIESCE_CONNECT authority = NO
    Indirect CREATE_EXTERNAL_ROUTINE authority = NO
    Indirect SYSMON authority = NO

Posting Permissions

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