I have this line of code that I need to test for other users:
[such and such]
This works when running AS the user, but I need to test this FOR a user in my own session. is there a way to do that ? Like if there was a parameter for user.
for testing purposes, I can do this another way without using dbms_session but would prefer to be as close to the actual logic as possible.