I reach my database server from my MacBook via SSH. You can login into this database as by using OS authentication.
MacBook:~ mangeles$ ssh [email protected] [email protected]'s password: Last login: Thu May 21 11:45:14 2015 from 172.31.12.51 [oracle@bd ~]$ . oraenv ORACLE_SID = [MF] ? PROD [oracle@bd ~]$ sqlplus / as sysdba SQL*Plus: Release 10.2.0.4.0 - Production on Thu May 21 11:46:17 2015 Copyright (c) 1982, 2007, Oracle. All Rights Reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options SQL>
I'm able to connect to the database using SQLDeveloper but I have to provide a username and a password. I can connect to all the databases as a SYS (through SSH) but I don't have the SYS password of all the databases and changing the password is not an option.
I want to know how I can use the OS Authentication in my SQLDev to login as I do in my terminal, without entering a password.