Database Security Products (MOSC)

MOSC Banner

database vault does not prevent already given privileges

edited Apr 19, 2020 1:48PM in Database Security Products (MOSC) 3 commentsAnswered

Hi,

we have  a  database vault enabled  database  version 19.6 .   There is a  realm  to protect a schema objects.  i will explain my problem  with an example :

The  Schema is   Schema1 .   There is a realm as  for Schema1

Schema1  has  a table as table1.   there is a role  as schema1_ro_role.  and this role  granted  for schema1.table1

The users  granted  schema1_ro_role    can  select   schema1.table1    .   The realm  does not  prevent  this select.

Is it  normal ?  What can i do  to prevent  accessing   users  select for this table   ?

Regards

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center