I have 2 users..U1 and U2.......... U1 contains some packages... I want U2 to compile U1 packages....... I have given Execute and debug grants to U2 but it says insufficient privilages and I can not give 'alter any procedure' grant as it will have access to compile any package which will be security issue.Do anyone have perfect solution on this? as i have tried almost all suggestions mentioned in the blogs.