Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question.

Asked: January 20, 2017 - 10:26 pm UTC

Last updated: January 21, 2017 - 4:07 am UTC

Version: 10.2.0

Viewed 1000+ times

You Asked

Hi,

We had created a user in Oracle db.

It contains some confidential Information.

So we are not interested to allow access to table rows in that schema from other schemas including sys.

Could please let me know how to restrict accessing data from other schema.


Thanks
Krishna

and Connor said...

By default, no other user can view that information in that schema.

The only ones that can are SYS plus any other user that has the "select any table" database privilege (which should be very very few ... or none).

There is nothing you can do to stop SYS from viewing the data, without considering larger scale solutions (like Datavault).

This is really about controlling access to SYS and having a robust security policy about who has what privileges in the database.

Hope this helps.



Is this answer out of date? If it is, please let us know via a Comment