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@xxxxxxxxx> 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