What are the challenges you face when working across database platforms? Take the survey

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?


  • Options
    Kurt_MKurt_M Posts: 187 Silver 1
    edited November 9, 2022 1:30AM

    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.


    Kind regards,

    Kurt McCormick
    Product Support Engineer, Redgate

    Need help? Take a look at our Help Center

Sign In or Register to comment.