comapring grants:Does it compares both system and object pri

gahuja

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

Eddie D

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