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/16
Message-ID: <32B557FB.37AA@sit.ulaval.ca>#1/1

Mike Irene wrote:
>
> Help a newbie out...here's a powder-puff question for the old-timers:
>
> How do you prevent a user from seeing PUBLIC tables? Do you create a
> ROLE and revoke privs? Can someone help with the syntax ?

Public tables are public. I dont know of any way to restrict access to public tables. If there are restrictions then the tables are not public, they are restricted to a group of users and this is why roles exists.

Michel lalonde. Received on Mon Dec 16 1996 - 00:00:00 CST

Original text of this message

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