This is an example how to create externally identified user in Oracle; i.e. if you want the os
oracle user to connect to database without supplying password run the following statement from
sqlplus:
SQL> create user OPS$ORACLE identified externally
default tablespace users
temporary tablespace temp;
SQL> grant dba to OPS$ORACLE
Note: it is recommended to set REMOTE_OS_AUTHENT to FALSE, otherwise you are opening a
security hole
|