Execute procedure

[mooks]

Hi,

I have create a procedure using the dba account and the procedure can be executed using this account. Then, I have grant execute on <procedure name> to mooks. However, when i execute the procedure as mooks, i got the following error.

BEGIN <procedure name>; END;

*
ERROR at line 1:
ORA-06550: line 1, column 7:
PLS-00201: identifier '<procedure name>' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Are there any other privileges that I have to grant to mooks before executing the procedure? I have tried grant create procedure to mooks and it doesnt work. Thanks!

[sreddy]

Seems your problem relates to this thread.

[url]http://www.dbasupport.com/forums/showthread.php?threadid=5673[/url]

[mooks]

Hi,

Thanks, i think i have solved the problem already. I think it could be that the procedure was not created as a public synonym which is why i cannot access it. Thanks anyway! :)