comapring grants:Does it compares both system and object pri
gahuja
Posts: 33
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
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
Thank you for your forum post.
Regarding your question,
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
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com