0 Replies Latest reply: Jun 17, 2011 6:58 AM by 587885 RSS

    db vault - how to lock  schema.

    587885
      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.