-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|