Hi Everybody ,

I have created a package named pkg1 then i created package body pkg1.there are two procedures (p()startup,p()emp_table)in this package.
Now the prob is i want to grant execute previledge to a particular user..

Grant execute on pkg1 to xyz;

it gives me grant succeded.

but when i run the second p()emp_table i get
identifier 'PKG1.EMP_TABLE' must be declared

i again tried to grant the execute previledge on the proc emp_table...using

GRANT EXECUTE ON PKG1.EMP_TABLE TO XYZ;

i am getting

ORA-04042: procedure, function, package, or package body does not exist

what i am doing wrong..pls help

Thanks in advance
Pras