Hi,
Is there a concept/functionality in Oracle databases that would provide the ability to "impersonate" a user, i.e., login as one Oracle DB user (a 'service account'), but then act as a different Oracle DB user, something similar to what's described here (for SQL Server):
Context Switching or Database Impersonation using EXEC AS - SQL Server Performance
The background of this question is that we want apps to be able to log into an Oracle database as a service account (e.g., myserviceaccount) but then to switch context to a user (e.g., in the case of a web app, the user that logged into the web app).
Is there a way to accomplish something like this in an Oracle database?
Thanks,
Jim