hi All,
i am trying to understand what is the impact of setting the remote_os_authent to false.
And the link i am looking at is --> Securing Client Connections: OS Authentication — DatabaseJournal.com
I test it on my lab and realized then even if setting REMOTE_OS_AUTHENT = false , i still can connect into the database via the OS authentication. The above link mention, you can only connect to the database via the OS authentication when you set remote_os_authent = true. So isn't that no difference ?
my TESTlab:
SQL> show parameter os
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_lost_write_protect string NONE
diagnostic_dest string /opts/u01/app/oracle
optimizer_index_cost_adj integer 100
os_authent_prefix string ops$ <====
os_roles boolean FALSE
remote_os_authent boolean FALSE <====
remote_os_roles boolean FALSE
timed_os_statistics integer 0
create OS james account:
[root@rcat ~]# useradd james
[root@rcat ~]# passwd james
Changing password for user james.
New password:
BAD PASSWORD: it is based on a dictionary word
BAD PASSWORD: is too simple
Retype new password:
passwd: all authentication tokens updated successfully. <==== done
connect into the database without any password:
[james@rcat ~]$ sqlplus /
SQL*Plus: Release 11.2.0.3.0 Production on Fri Oct 14 16:22:44 2016
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> exit