Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Posts
    60

    Unanswered: stored procedure compile error

    udb ver 8.1 aix 5.2

    we are trying to compile a SP using
    db2 -td@ -f new_sp.sql

    but its giving error
    DB21034E The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:
    SQL0551N "GEN01" does not have the privilege to perform operation "SELECT" on
    object "LEN.CM_TRAN". LINE NUMBER=259. SQLSTATE=42501

    but the same user can select any rows from LEN.CM_TRAN table. So why it gives such error.

    What could be wrong?

    Thanks,
    j

  2. #2
    Join Date
    Mar 2003
    Posts
    60
    When I granted 'select' right on this table to the user it could compile the SP.
    But this user already had select right on this table through 'group' membership and could run select queries before.

    Why do we have to grant 'select' to the user just to compile the SP?

    we have udb ver 8.1 on aix 5.2

Posting Permissions

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