Is there a work around for the below problem –
Scenario – after applying patches to the database, automatically the replaced or newly added objects are dropped from the roles along with its original pre-set permissions due to the patches. All the replaced objects needs to be reassigned permissions and added to the roles.
any solution/suggestions/recommendations greatly appreciated -
Regards,