Looks like a mission impossible .I can not anyidea other than the bellow one:1. Extract all the PL/SQL under this user to a SQL file
2. Replace some particular word .
3. Run this SQL file Your question might be how to do 1 . It's easy if you have some 3rd party SQL utility like SQL navigatore , PL/SQL develop and TOad
2. Replace some particular word .
3. Run this SQL file Your question might be how to do 1 . It's easy if you have some 3rd party SQL utility like SQL navigatore , PL/SQL develop and TOad
revoke execute on procedure procedure_name
from user_name;
问题是:如果此用户是这些过程的所有者,那么此语句对于此用户是否有效呢?