How To Update Encrypted Password for all user id's using Update Query [message #652351] |
Tue, 07 June 2016 12:30 |
|
ramraju20000
Messages: 8 Registered: September 2012
|
Junior Member |
|
|
Hi All,
I have a table which contains the "Hash" Column as Encrypted Password for each userd id.
The Encrypted password using SHA-512 Algorithm, I want to update the Password for all userid's to a default password in one shot.
can you please suggest how can i achieve this using SQL Update query ...by storing the encrypted password in the Hash coulmn
(Example : if i want to update my default pasword as "p@ssword123" how can i encrypt this using sha 512 and store in that column)
Please suggest on this.
Thanks in Advance.
Ram
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: How To Update Encrypted Password for all user id's using Update Query [message #652418 is a reply to message #652414] |
Wed, 08 June 2016 09:14 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
EdStevens wrote on Wed, 08 June 2016 08:39
Really?
Have you seen what happens when you 'sqlplus myuser/p@ssword123@mydb'
Not an issue, just an inconvenience of using quoted names:
SQL> grant create session to u1 identified by p@ssword123;
grant create session to u1 identified by p@ssword123
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> grant create session to u1 identified by "p@ssword123";
Grant succeeded.
SQL> connect u1/p@ssword123@pdb1sol12
ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified
Warning: You are no longer connected to ORACLE.
SQL> connect u1/"p@ssword123"@pdb1sol12
Connected.
SQL>
SY.
[Updated on: Wed, 08 June 2016 09:15] Report message to a moderator
|
|
|
|
|