467,882 Members | 1,221 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,882 developers. It's quick & easy.

DB2 execute permissions issue

I logon with the same username and password as someone else, yet I
can not update the DB2 tables. I get the following

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 "FADAPP" does not have the privilege to perform operation "EXECUTE"
on object "NULLID.SQLC2E07". SQLSTATE=42501

Is there something I can change in my setup profile.
Aug 14 '07 #1
  • viewed: 2964
Share:
1 Reply
Jal
Arnold,
execute the foll command:

GRANT EXECUTE ON PACKAGE NULLID.SQLC2E07 TO USER FADAPP;

there would be some packages, you need to grant execute on all.

This has to be done by someone who has DBADM authority on the Database

Jalaj
Aug 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by HD | last post: by
2 posts views Thread by Mark MacRae | last post: by
4 posts views Thread by Chris | last post: by
5 posts views Thread by Good Man | last post: by
6 posts views Thread by =?Utf-8?B?RGF2ZQ==?= | last post: by
reply views Thread by Tim Payne | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.