Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't create cursor on dba_synonyms, what's wrong?
Only users that have been granted access to dba_synonyms will be able to view it, also you will need to create a synonym for it otherwise you will only be able to refer to it as sys.dba_synonyms rather than dba_synonyms;
You need to run the commands
grant select on dba_synonyms to <procedure_owner>; when logged in as sys (or system)
create synonym dba_synonyms for sys.dba_synonyms; when logged in as the procedure owner
Hope this helps,
Ian Received on Mon Sep 29 1997 - 00:00:00 CDT