authentication - How to authenticate Oracle login using encrypted password -

-

we connecting oracle using kornshell (ksh) scripts, use sql*plus connect oracle. oracle database on same solaris box. currently, storing oracle user id , password (plain text) in file in .ssh folder of connecting user, 400 permission bits.

the dbas objecting way of working, citing fact using plain text password authentication. when offered encode password using base64, still did not idea, citing still decrypt password in shell script , transmit password on network.

now, want understand this-

  1. i have been reading oracle encrypts/hashes password string, before transmitting it. can not find reference right though, however, still want confirm understanding. this? on 11g r2, make difference?

  2. would able login sql*plus without decrypting password hash? e.g., dbas set password, pass on hash me. put in file, , supply sql*plus parameter. there way kind of authentication work? know tools allow that, if encode using tool, able decrypt value , use authentication. oracle?

help me fellas.

its been while since doing (and don't have linux box handy atm), can try hide details ps:

echo password | sqlplus -s username@database @myscript.sql

note -s silent mode sqlplus. believe can put password in "protected" file (i use term loosely, set bits 400) , cat file, piping sqlplus above.

edit: if dbas concerned passwords, how using no passwords. can try os authentication, need setup first. example:

--in oracle, create new user

create user ops$batch_user identified externally; grant connect ops$batch_user;

-- in unix (login batch_user, or use su command)

export oracle_home=/app/oracle/product/11.2 export path=$path:$oracle_home/bin export oracle_sid=dev sqlplus /

note no passwords used since user authenticated os. less complicated oracle wallet imo, not perfect either.


Comments

Post a Comment

Popular posts from this blog

javascript - Laravel datatable invalid JSON response -

-
everything work fine on code below fetch user logs: js: <script> $(document).ready(function () { var table =$('#systemlogs').datatable({ responsive: true, processing: true, serverside: true, "language": { "url": "/datatables/media/plug-in/persian.json" }, ajax: '{!! url('/admin/systemlogs/data/systemlogsdatatable') !!}', columns: [ { data: 'name', name: 'name' }, { data: 'message_text', name: 'message_text' }, { data: 'remote_addr', name: 'remote_addr' }, { data: 'log_created_at', name: 'management_logs.created_at' }, { data: 'log_updated_at', name: 'management_logs.updated_at' }, ] }); }); </script> routes: route::get('/systemlogs/data/systemlogsdatatable','systemlogscontrolle...
Read more

java - Exception in thread "main" org.springframework.context.ApplicationContextException: Unable to start embedded container; -

-
i getting error when run spring application: exception in thread "main" org.springframework.context.applicationcontextexception: unable start embedded container; nested exception org.springframework.context.applicationcontextexception: unable start embeddedwebapplicationcontext due missing embeddedservletcontainerfactory bean. @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.onrefresh(embeddedwebapplicationcontext.java:124) @ org.springframework.context.support.abstractapplicationcontext.refresh(abstractapplicationcontext.java:476) @ org.springframework.boot.context.embedded.embeddedwebapplicationcontext.refresh(embeddedwebapplicationcontext.java:109) @ org.springframework.boot.springapplication.refresh(springapplication.java:691) @ org.springframework.boot.springapplication.run(springapplication.java:320) @ org.springframework.boot.springapplication.run(springapplication.java:952) @ org.springframework.boot.springa...
Read more

sql server 2008 - My Sql Code Get An Error Of Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '8:45 AM' to data type int -

-
msg 245, level 16, state 1, line 1 conversion failed when converting varchar value '8:45 am' data type int. script declare @specimenid bigint = 0, @script varchar(max); declare @starttime int = (select convert(int,substring(start_time,0,charindex(':', start_time)) - 12) appt appt._id=112601) --select @starttime set @script = 'select distinct ptlast_name + '', '' + pt.first_name patient_name, dbo.formatdate(pt.dob,''mm/dd/yyyy'') dob, (convert(varchar, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end)) + ''/'' + convert(varchar, (datediff(m, dateadd(yy, (datediff(yy, dob, appt_date) - case when (month(dob) > month(appt_date)) or (month(dob) = month(appt_date) , day(dob) > day(appt_date)) 1 else 0 end), d...
Read more