Posted: 11 Aug 2017 7:56 EDT Last activity: 14 Aug 2017 6:57 EDT
Regarding Dropping of Procedure from Rule Schema after Upgrade to 7.2.2
Recently we have upgraded our application from 6.2 SP2 to 7.2.2 after upgrade I can see 6 procedures are there which present in now both rule and data schema but all these 6 procedure are now invalid in rule schema as the table they are pointing to belong to now data schema so I am not sure whether we should delete these procedures or should give grant to the rule schema on these tables which these procedures are referring to, please clarify my confusion. Below are the mentioned procedures.
Sudhanshu Kumar Yadav
***Updated by moderator: Lochan to add Categories***
Yes, you should drop the unused stored procedures. If you have not already done so you should also use the optimize schema tool to identify the unused tables in the rules and data schema to remove. The procedures you listed only belong in the data schema.