Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

EXECUTE privilege

Status
Not open for further replies.
oana12

oana12

Programmer
Jan 6, 2005
21
CA
Hi,
Which is the command in DB2 to give EXECUTE privileges for a user? ( I want to use a single command for all the packages, procedures, functions).

I don't want to use this:
GRANT EXECUTE ON PACKAGE x.P0002089 TO USER X;

Thanks.
 
Status
Not open for further replies.

Similar threads

Cenois
  • Locked
  • Question
Execute Immediate
Replies
1
Views
60
Mercury2
Mercury2
iren
  • Locked
  • Question
ERROR: CLI execute error:(SQL0206N or SQL0408N) . Neither way works
Replies
1
Views
48
bibulous
bibulous
snufse1
  • Locked
  • Question
Execute command on db2/400 fron Sequel Server 2005
Replies
5
Views
54
fredericofonseca
fredericofonseca
Db2curiosity
  • Locked
  • Question
Prepare Execute is not doing anything but no error message
Replies
2
Views
40
Db2curiosity
Db2curiosity
shuchis
  • Locked
  • Question
How to capture No of Rows affected in case of Execute statement (CALL)
Replies
0
Views
31
shuchis
shuchis

Part and Inventory Search

Sponsor

Back
Top