As long as the ID that has created the procedure has the access needed for
the table inserts, and you then grant execute access on the procedure to a
user that does not have specific access to the table, the procedure should
work just fine when the user executes it.

Al Glinter, Lead Database Administrator
Lord and Taylor Solution Center
St. Louis, MO




"Khan Nadeem "
<db2udbdba-ezmlms
hield-x51215824.x To
[Email Address Removed] "LazyDBA Discussion"
A.com> <[Email address protected]
cc
05/28/2007 01:52
AM Subject
reg Stored proc ........urgent











Hi gurus



I just wanted to knw

That if a user has privileges to run Stored procedures I mean to create
procedures



But doesn't have privilege to insert data in a table referred by
procedure

So in that case will it be possible to insert data from SP in that
particular table





Hope my question was clear





Do reply



Thanks



Nadeem



This message contains information that may be privileged or confidential
and is the property of the Capgemini Group. It is intended only for the
person to whom it is addressed. If you are not the intended recipient, you
are not authorized to read, print, retain, copy, disseminate, distribute,
or use this message or any part thereof. If you receive this message in
error, please notify the sender immediately and delete all copies of this
message.


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




DB2 & UDB email list listserv db2-l LazyDBA home page