Oracle Password Encryption Function

[marceloplis]

Personnel, when creating a user: Create User Test Identified by "AAA123"; it writes in dba_users the encrypted password with 16 characters: B531D90349A117C4

There is some function that Return exactly this string B531D90349A117C4 If I pass as parameter "AAA123" ??? Is it possible to use the same Oracle function ??


Thanks.

[Trevisolli]

Brother, exactly which he uses I do not know.
But if you want to do something similar, take a look at this topic: http://en.glufke.net/oracle/post-433.html.

[marceloplis]

Trevisolli, thanks for the tip, but what I need is exactly the function used by Oracle, because after doing what I have to do I will use the following command [

Select all

CREATE USER TESTE IDENTIFIED BY VALUES "B531D90349A117C4";

in a trigger of a user table that I created, that in addition to username and password, there are several other fields !!! The intention is to replicate the data from the user table and create the user (Create User ...) with the same password on all banks.

valeu.

[Trevisolli]

Well, I have another tip, which may work out:

1) Create the user at the base and "Wait" the popular Oracle to DBA_Users;
2) Search in this field encrypted by Oracle, for this user created;
3) Replicate the information on your created table;

I think you can do what you want in this way.
Whatever it sends there.

[marceloplis]

Trevisolli, if I just registered the user your tips until they would work, but the problem is that how can I change the user registration tb, what to do whenever the password ??

Come on, there, I suppose the user registration:
1 - I enter with the information in the user registration on the front-end system with password = "123456";
2 - No After Insert, Populate DBA_Users, I recover the encrypted password and make a password field update in the table;
3 - Then replication:
a) Go user insert with password = "123456";
b) Go the Cryptographed password update;

Now, see if I have an update trigger, so that you change the password, it will occur that at the time I do the insert and to do the update of the password field, will shoot the trigger Update, what will generate a different password !!!

What to do ??

[Trevisolli]

A Brother tip:

When he changes the password, do the following:
1) Change on your user table to 654321;
2) Send an alter in the DBA_USERS with the change syntax

Select all

ALTER USER X IDENTIFIED BY 654321;

3) recovers this encrypted password;
4) Gives an update on your table again;

One tip would, whenever you give an update in this field, go to DBA_Users Search for encrypted password.

Select all

 
CREATE USER teste_1 IDENTIFIED BY trevisolli -- Senha Gerada: 8596D8B862E76899; 
ALTER USER teste_1 IDENTIFIED BY illosivert; -- Senha Gerada: 210432169BE2CD63; 

I believe it works.
Whatever, send it there.