Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: No PUBLIC tables??
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