Ignore Rules for grants made from other schemas' objects

BFLAHERTY

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 ;

But this grant should:

GRANT READ ON .table1 TO zz;

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

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