| grant back-end procedure in a package [message #87042] |
Wed, 01 December 2004 11:25  |
Zun Xing Li
Messages: 19
Registered: November 2004
|
Junior Member |
|
|
I have a package demo_mail and have a procedure called mail in this package. How do I grant the execute privilege to that procedure? I did as below:
SQL> grant execute on demo_mail.mail to public;
grant execute on demo_mail.mail to public
*
ERROR at line 1:
ORA-04042: procedure, function, package, or package body does not exist
What shall I do?
Thanks!
Li
|
|
|
|
| Re: grant back-end procedure in a package [message #87049 is a reply to message #87042] |
Wed, 01 December 2004 20:34  |
Frank
Messages: 7901
Registered: March 2000
|
Senior Member |
|
|
You can only grant access to a complete package.
If you really need to grant that 1 procedure, you could create a stand-alone procedure that calls the packaged procedure and grant access to that standalone procedure.
hth
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
