comapring grants:Does it compares both system and object pri

gahujagahuja Posts: 33
edited November 26, 2014 11:41AM in Schema Compare for Oracle
comapring grants:Does it compares both system level and object level grants

In one of the schema compairson deployment scripts I see "GRANT FLASHBACK ON X TO Y" ,would like to know does the schema comparison compares both object and system level priveleges if so "Ignore grants" will ignore both the comparison
Is it possible to ignore just the system level comparison or just object level priveleges

Comments

  • Eddie DEddie D Posts: 1,806 Rose Gold 5
    Hi

    Thank you for your forum post.

    Regarding your question,
    comapring grants:Does it compares both system level and object level grants

    Schema Compare for Oracle does not compare System Level grants. It only compares the object level grants.

    If you wish to ignore the object level grants, simply enable or check the 'Ignore Permissions' option in the project configuration (Edit Project ->Options Tab ->Ignore section ->Ignore Permissions).

    I hope the above answers your question.

    Many Thanks
    Eddie
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.