Given:
User_A Owns procedure 'MY_PROCEDURE'.
User_B originally compiles procedure ''USER_A.MY_PROCEDURE", thereby
allowing 'MY_PROCEDURE" to be able to do whatever User_B
can.
User_C recompiles "USER_A.MY_PROCEDURE" by issuing the "ALTER
PROCEDURE USER_A.MY_PROCEDURE COMPILE;" command.
Question:
Is procedure "USER_A.MY_PROCEDURE" now able to do
whatever User C can do instead of User B ?? Or does it retain the
authority from User_B instead.
Thanks
Kevin
