Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: No PUBLIC tables??
Lun Wing San (Oracle) wrote:
>
> Mike Irene wrote:
>
> > How do you prevent a user from seeing PUBLIC tables? Do you create a
> > ROLE and revoke privs? Can someone help with the syntax ?
>
> You can only create public synonym and public dblink in PUBLIC.
>
> ---
> Name : Lun Wing San
> Title : Oracle Application Developer of Hong Kong Productivity Council
> Oracle Database Administrator and System Administrator of QRC
> Phone : (852)27885841
How about GRANT SELECT TO PUBLIC ???
Michel Lalonde. Received on Thu Dec 19 1996 - 00:00:00 CST
![]() |
![]() |