How to Switch sessions before any create or drop statement?
Hi,
Can you please provide some suggestion on how to implement the following :-
1.After login we are switching a user to a Service Account.
2.During a create or drop statement we want to switch it to Original Schema.
3.After the ddl operation we want to switch it back to the Service Account.
Pls note: In case of any create or drop statement executed on the Service Account (Service Schema), it has to switch to the Original Schema and perform the task. Once done it has to return back to the Service Account. For other statements it has to be in the Service Account.
Can you please provide some suggestion on how to implement the following :-
1.After login we are switching a user to a Service Account.
2.During a create or drop statement we want to switch it to Original Schema.
3.After the ddl operation we want to switch it back to the Service Account.
Pls note: In case of any create or drop statement executed on the Service Account (Service Schema), it has to switch to the Original Schema and perform the task. Once done it has to return back to the Service Account. For other statements it has to be in the Service Account.
0