Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Unanswered: DB2LOOK issuing SQL1092N


    I have a user reporting an error while trying to use DB2LOOK who's getting error SQL1092N, although this user belongs to the designated LDAP group holding DBADM rights.

    Here's the command she's trying to execute

    db2look -d <dbname> -t TUPT_PUESTO_TRABAJO -a -l -x -c -o DDLTUPT.sql

    I wonder if DB2LOOK is working OK with our LDAP security setup....

    BTW: We're running DB2 LUW V8.2....I know, I know....we're very far behind... :-)

    Any hints...?

    Enrique Valdez

  2. #2
    Join Date
    Jan 2007
    Jena, Germany
    SQL1092N authorization-ID does not have the authority to perform the requested command or operation.
    Does the user who runs db2look have all the necessary privileges to access the DB2 catalog tables? Maybe that user is not allowed to read SYSCAT.TABLES, SYSCAT.COLUMNS or some other catalog things because privileges were revoked or not granted?

    Note: I'm just guessing myself. Did you have a look at the db2diag output?
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

Posting Permissions

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