November 18, 2006

Oracle password

Writing about web page http://www.dizwell.com/dokuwiki/doku.php?id=changingpasswordwithvalues

You can change a user’s password without knowing its values. Then change it back using the hashed values from dba_users

SQL> select username, password from dba_users where username = 'SCOTT';
SQL> alter user scott identified by newpassword;
SQL> alter user scott identified by values 'F894844C34402B67';

I wonder whether the following can be used to hide the password in connection pool configuration file.
Seems not, it is from a top link configuration file.

<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<connection-url>jdbc:oracle:thin:@insn104a.idc.oracle.com:1522:ora9idb</connection-url>
<user-name>hr</user-name>
<encrypted-password>62C32F70E98297522AD97E15439FAC0E</encrypted-password>

- No comments Not publicly viewable


Add a comment

You are not allowed to comment on this entry as it has restricted commenting permissions.

Search this blog

Search Warwick Blogs

 

Tags

Most recent comments

  • Oracle 11g is the clear leader in this area. Oracle has invested heavily into self–tuning capabiliti… by shaane on this entry
  • All the features are very nice.I like Repair Advisors the most.Oracle 10G introduced some of the dat… by lucy on this entry
  • "logical standby failed to re–start, I am also getting the same error. I have search on internet and… by anemia on this entry
  • Thanks for the nice information because from last three days i am stuck on this problem…. by robot vacuum on this entry
  • So what happen City speed dating when you tried this coding once in your PC.. Please tell me so i am… by John Bergeron on this entry
Not signed in
Sign in

Powered by BlogBuilder
© MMXXII