Hi all,
I created a user who has resource privilege with admin_option. This user granted resource privilege to another developer who wants to create a function. The developer has access to all synonyms and tables in the database; however, when the developer tries to create a particular function he gets PLS-00201 error message. what's interesing is that he can select from the table that the error message is pointing to.
Does know why this is happening. And what must I do to resovle this issue.
Thanks.
leonard905
leonard905@yahoo.com