-
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
-
exec owner.PKG1.EMP_TABLE()
-
Hi Pando
I am still getting the error..
SQL> GRANT EXECUTE ON ACPART.PKG1.EMP_TABLE TO PUBLIC;
GRANT EXECUTE ON ACPART.PKG1.EMP_TABLE TO PUBLIC
*
ERROR at line 1:
ORA-00905: missing keyword
THANKS
pras
-
Did the 2nd user (XYZ) ran:
Code:
EXEC USER_1.PKG1.EMP_TABLE;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
hmm I dont think I said anything about grant did I
-
Originally posted by pando
hmm I dont think I said anything about grant did I
I don't think so :-)
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Thanks
Hi Pando/Julian
Actually i am using these procedures in Portal 3.0..Anyway after closing the instance and again starting i am able to run the procedure.
Thanks again
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
|