grant for package

[vbaskar]

hi

i have 2 users USERA and USERB. I have a package called INTEG in USERA !! i wanted to create a public synonym on INTEG to USERB !! i ve connected as system and gave the following command

create public synonym INTEGRAT for INTEG;
grant execute on integrat to USERB..

But is giving error !! can somebody suggest how do go abt this..

[sambavan]

Why don't you just give

from userA
GRANT EXECUTE ON integ TO userb;


Sam

[jmodic]

Your public synonym points to a nonexisting object. You created the public synonym with user SYSTEM without specifying the owner of the package INTEG. So unless user SYSTEM has some kind of object with this same name in his schema the synonym points nowhere! What you should do now is:

CONNECT SYSTEM;
DROP PUBLIC SYNONYM integrat;
CREATE PUBLIC SYNONYM integrat FOR userA.integ;

CONNECT userA;
GRANT EXECUTE ON integ TO userB;

HTH,