How can we help you today? How can we help you today?

Ignore Rules for grants made from other schemas' objects

I have two schemas (XX, YY) in Oracle 12c set up for source control with all objects enabled.  I do not want to see Object Grants made for these two schemas by other non-controlled schemas (ZZ).  For example this grant should not show up for me:

GRANT READ ON zz.table1 TO xx;

But this grant should:

GRANT READ ON xx.table1 TO zz;

Is there a rule that can be applied to filter out grants made for non-source controlled schema objects?
BFLAHERTY
0

Comments

1 comment

Sort by
  • Kurt_M
    Hi @BFLAHERTY

    Unfortunately, I don't believe there is an ignore rule, comparison option or filter that will exactly do what you'd like. Since the rules are applied to an object or a schema, it won't affect the grants because they are both coming through from schema xx. I tested in my own platform with your above example, and I wasn't able to remove the grant from the separate schema I'm afraid.

    My best suggestion would be to create a feature request over on our user voice forum.

    https://redgate.uservoice.com/forums/174014-oracle?category_id=55136
    Kurt_M
    0

Add comment

Please sign in to leave a comment.