This discussion is archived
0 Replies Latest reply: Jun 17, 2011 4:58 AM by 587885 RSS

db vault - how to lock  schema.

587885 Newbie
Currently Being Moderated
Hi ,

Is it possible using database vault to perform the following:
Schema Name : userA
Schema Objects: A, B, C (all tables)

How do I make another Schema e.g. userB the realm owner of the following objects
1) userA.A
2) userA.B

Basically, I need to ensure that userA can only access object C and is not able to access the other 2 objects(A,B) in its own schema.

Is this possible, if so, how?

Thank you.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points