grant all on apps.hr_general to rabie with grant option;

ofer

-----Original Message-----
From: Musa Mohd. M. Mansor
[mailto:oracledba-ezmlmshield-x35834922.[Email address protected]
Sent: Wednesday, August 02, 2006 7:50 AM
To: LazyDBA Discussion
Subject: FW: grant execute privilege on package





Hi,



I need help for grant execute privilege on package and all function
inside this package to user.

I do this command but not working fine

grant execute on apps.hr_general to rabie



After granted when execute query error come



ORA-00942: table or view does not exist

ORA-06512: at "APPS.HR_GENERAL", line 1801

ORA-06512: at "APPS.HR_GENERAL", line 1814



Plz help?????



Regards,



Musa Mmansor,

DB Administrator,

Saudi Arabia - Riyadh,

Kudu Corporation,

Tel: +96614191440 Ext.: 260,

Fax: +96614191322,

E-Mail: [Email address protected] <mailto:[Email address protected] .





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html




**********************************************************************
The information contained in this e-mail message may be
privileged and confidential. The information is intended only
for the use of the individual or entity named above. If the
reader of this message is not the intended recipient, you are
hereby notified that any dissemination, distribution or copying
of this communication is strictly prohibited. If you have
received this communication in error, please notify us
immediately by telephone, or by e-mail and delete the message
from your computer. Thank you!
Unless otherwise stated, any views or opinions expressed in
this e-mail are solely those of the author and do not represent those of
Barak I.T.C (1995) The International Telecommunications Services Corp. Ltd.
**********************************************************************


Oracle LazyDBA home page