By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,611 Members | 2,296 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,611 IT Pros & Developers. It's quick & easy.

DB2 execute permissions issue

P: 1
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
Share this Question
Share on Google+
1 Reply


P: 10
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.