Hi all,

I have four databases on the same server, does anyone know how to configure OS authentication to connect as sysdba? At the moment, am connecting as follows:

sqlplus "[Email Address Removed] /as sysdba"
sqlplus "sys/[Email Address Removed] /as sysdba"

The first option will prompt for the SYS password. Since am logged into the box anyway and the databases are on the same machine, I want to use OS authentication instead. Is it as simple as doing a create user with the OPS$ appended to the OS USER?




Oracle LazyDBA home page