Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Can't create cursor on dba_synonyms, what's wrong?

Re: Can't create cursor on dba_synonyms, what's wrong?

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/09/29
Message-ID: <342F9B9E.2277@gatwick.geco-prakla.slb.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US