How do I use Oracles OS-Authentication (users identified externally)?
To set up Oracle to authenticate a user against the OS, first create a user in linux/unix, then log into oracle as the sys user and create a corresponding user as follows. In this example, we’ll assume that you created an OS-level user named mused: CREATE USER ops$mused IDENTIFIED EXTERNALLY GRANT CONNECT TO ops$mused Now you can log in as mused and connect to the database using sqlplus / and you will not be prompted for a username and password. In the sqlrelay.conf file, set the runasuser attribute of the instance tag to the user that you want to connect as and leave out the user, password and oracle_sid parameters of the string attribute of the connection tag. For example, here’s a normal (non-OS-authentication) configuration which connects to the ora1 instance of oracle using testuser/testpassword:
