Re: Confused about Synonyms

Compiling pl/sql and creating views requires explicit access to the objects that are being referenced if you are not the owner of the objects. Granting access through a role is not sufficient, you must be granted either execute ( pl/sql ) or select ( tables ) on the objects you are referencing.

With pl/sql, once you have compiled using privileges to the objects, other users can access those objects through the pl/sql without having access to the objects themselves, they will only need execute on the pl/sql object(s).

Phil Cook
Certified Oracle DBA / Oracle Education DBA Masters

Graham Thornton <dangermouse_at_prodigy.nospam.net> wrote in article <01bcca04$35a7ca80$b0f7c9c7_at_dangermouse>...
> I have created a table called SYS_DATATYPE under one user,
> and provided a public synonym so that everyone else can
> access it.
>
> I can describe, select, insert and delete from other users.
>
> However, when I try to compile a PL/SQL package with the a
> variable defined as:
>
> myVariable in out SYS_DATATYPE.COBOL_STATUS%type
>
> Oracle tells me that SYS_DATATYPE is not defined.
>
> Chapter 6 of the PL/SQL User's Guide and Reference seems to
> suggest this should work.
>
> Any suggestions?
>
> Thanks in advance
>
> Graham Thornton
>
> ------------------------
>
> remove the .nospam from the E-mail address to reply.
>
  Received on Thu Sep 25 1997 - 00:00:00 CDT