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

    Unanswered: DB2 Command center - Execute Privilege


    I get the following message when I try to submit any SQL in my command center against one data source (production). It works fine for other data sources.

    SQL0551N "MyID" does not have the privilege to perform operation "EXECUTE
    PACKAGE" on object "NULLID.SQLC2D03". SQLSTATE=42501

    I have full access against production tables and the datasource parameters are correct. I am able to establish connection but not able to execute even a SELECT statement. We use IBM DB2 for Windows NT ver 7.

    I would highly appreciate if you can let me know if this can be fixed on the client.


  2. #2
    Join Date
    Oct 2003
    I have seen this happen before. Occasionally, a bind doesn't get granted to public.

    Try logging in as the admin user in Control Center, then grant execute privilege on that package.

Posting Permissions

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