4 Replies Latest reply: Jun 20, 2012 2:03 PM by JamesGordon RSS

    Block a roles privs that was granted to another role

    JamesGordon
      I don't think I explained that very well in the title...

      create role role_a;
      grant select, insert, update on table a to role_a;
      grant select, insert, update on table b to role_a;
      grant select, insert, update on table c to role_a;

      create role role_b;
      grant role_a to role_b;
      revoke insert, update on table b from role_b;

      What I need to do is revoke insert, update from role_b.
      This example is over simplified but I hope you get the gist of the problem.