Defining AUTHID CURRENT_USER dynamically
HI,
I would like to set up all my Oracle 10G procedures and functions to be defined as AUTHID CURRENT_USER dynamically, such as
ALTER PROCEDURE MYPROC1 AUTHID CURRENT_USER.
Is there a way to do this dynamically or do I have to owerwrite every sources to do this ?
Thx in advance.
I would like to set up all my Oracle 10G procedures and functions to be defined as AUTHID CURRENT_USER dynamically, such as
ALTER PROCEDURE MYPROC1 AUTHID CURRENT_USER.
Is there a way to do this dynamically or do I have to owerwrite every sources to do this ?
Thx in advance.
0