Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Setting and extracting credential passwords

Little JimmyAug 14 2024 — edited Aug 14 2024

I want to create a credential using a hashed password.

Like this but with a hash instead of clear text password:

DBMS_CREDENTIAL.CREATE_CREDENTIAL(
credential_name => 'ANYNAME',
username => 'oracle',
password => <password>,
enabled => TRUE);

Same way you would do it with a user something like this:

ALTER USER anyuser IDENTIFIED BY VALUES ‘hash’;

It would also be helpful to extract the hash from the existing credential.

Thanks.

Edit: Oh, and this is a19 database. I think that's all the relevant information.

Comments
Post Details
Added on Aug 14 2024
0 comments
275 views