Limit public table access
From: Jeff Chirco <backseatdba_at_gmail.com>
Date: Tue, 12 Mar 2019 10:56:51 -0700
Message-ID: <CAKsxbLqTUtd-A+DUpexX6AF_B7dAW-E3jzBqWcaXwOiJBcKEaA_at_mail.gmail.com>
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?
Date: Tue, 12 Mar 2019 10:56:51 -0700
Message-ID: <CAKsxbLqTUtd-A+DUpexX6AF_B7dAW-E3jzBqWcaXwOiJBcKEaA_at_mail.gmail.com>
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-lReceived on Tue Mar 12 2019 - 18:56:51 CET