Re: Limit public table access

Typically build a custom view to list only target tables and present that to this tool ?
Is it hard-coded to query only ALL_TABLES ?

On Wed, 13 Mar 2019, 01:58 Jeff Chirco, <backseatdba_at_gmail.com> wrote:

> Ok so we have a reporting tool for users that uses their Oracle account.
> When the first connect to it and get a table list they see all tables they
> have access to through PUBLIC. This obvisouly confuses them and I would
> like to remove this. I've tested removing objects from public but that
> didn't go well when it came time to patch the database. A bunch of things
> failed. Oracle must want things granted to public for a reason. But is
> there another way around to prevent some users from seeing public?
>
> Thanks,
> Jeff
>

--
http://www.freelists.org/webpage/oracle-l