Folks! - I need a little help, please.
I created a package with procedures as a user with dba access to my instance (8i release 2 on Solaris 2.7). It runs fine when I run it as that user.
I am having no luck granting access to this package to other users!
Create or Replace Package This_Package is
Procedure My_Proc (input in varchar2);
Create or Replace Package BODY This_Package is
Procedure My_Proc (input in varchar2) is
MY PROC HERE;
create public synonym This_Package for MY_USERID.This_Package;
grant all on This_Package to SOME_OTHER_USER;
But, when SOME_OTHER_USER runs the package, he gets this error:
identifier 'THIS_PACKAGE.MY_PROC' must be declared.
Could someone please tell me what I am doing wrong?!
Thanks in advance!
Are they specifying the owner of the package? Instead of saying pack1(); They would have to say owner.pack1();
lesstjm - thanks for your reply!
Yes, putting the owner on the package call does work. But, why doesn't creating the public synonym get me around having to specify the owner?