title: How to execute a statement in oracle as a different user?
body: <p>I have created a new user account and gave them select and update permission on a table. Now I want to test if everything is correct by running select statement on those tables as the newly created user. Is there a command that would allow to 'run as'? If not is there a command that allows one to switch the active user?</p>