Some organizations may require the ability for users to share a common Oracle schema for the purpose of loading data or the ability to perform a reconcile and post operation with versions that are protected or owned by a different user.
These tasks and many others can be accomplished through the use of Oracle proxy authentication. Oracle proxy authentication allows a privileged user to connect to the Oracle instance using their own credentials but as a different user, thus automatically inheriting the user's privileges and permissions.
For example, a user named giseditor can connect by way of the proxy authentication as the gisadmin user. Any objects that the user creates, such as feature classes or tables, will be created as the gisadmin's user.
Instructions provided describe how to use Oracle proxy authentication with ArcGIS.
CREATE USER giseditor IDENTIFIED BY giseditor
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp;
GRANT CREATE SESSION, CREATE TABLE TO giseditor;
ALTER USER gisadmin GRANT CONNECT THROUGH giseditor;
Notice the use of square brackets to denote the user account, gisadmin, which is the proxy account.
It is sometimes common to use proxy authentication in combination with operating system authentication, thereby ensuring only the user who has connected to the operating system has the required privileges to proxy to another Oracle user.
ALTER USER gisadmin REVOKE CONNECT THROUGH giseditor;