Oracle Basic Authentication Methods

You want to use a batch jobs so batch jobs should not have password embedded in the command line or script.You can use Oracle Basic authentication methods for implementing no password login credentials.sqlplus /nologconn / as sysdbashow parameters OS_AUTHENT_PREFIXos_authent_prefix ops$Alter system set OS_AUTHENT_PREFIX=' ' scope=spfile;shu immediatestartupconn system/oraclecreed user zekeriya identified externally;grant create session,resource to zekeriya;operating … Continue reading Oracle Basic Authentication Methods