This content has been marked as final. Show 3 replies
user645399 wrote:Dear Nith
I want to give access to another user to access a package in my schema.
How should I be doing it?
I saw in this page but how to refer to the different schema the package is residing?
Please guide me.
Here's the command:
Kamran Agayev A.
grant execute on your_schema.your_package to the_second_user;
- - - - - - - - - - - - - - - - - - - - -
My Oracle Video Tutorials - http://kamranagayev.wordpress.com/oracle-video-tutorials/
Hi,1 person found this helpful
You can use
GRANT EXECUTE ON [OWNER].[PACKAGE] TO xxx;
Thanks to both of you.
I have another related question which I will post in another thread.