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: No PUBLIC tables??

Re: No PUBLIC tables??

From: <michel.lalonde_at_sit.ulaval.ca>
Date: 1996/12/19
Message-ID: <32B9A156.1891@sit.ulaval.ca>#1/1

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

Original text of this message

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