Database Administration (MOSC)

MOSC Banner

password internals

edited Apr 18, 2019 10:31AM in Database Administration (MOSC) 4 comments

Oracle 12.1.0.2 SE-2, non-multitenant

Oracle Linux 6

In investigating another question, I've taken a side-trip and have a question about that .. (isn't that always the case?)

Reference this article:  https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/changes-in-oracle-database-12c-password-hashes/

So I run this query:

https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/changes-in-oracle-database-12c-password-hashes/

set echo on feedback on verify on trimsp on lines 256 pages 55col username for a21col account_status for a15col password_versions for a17col pswd_hashes for a63col password for a32spo doit.logselect a.username,       a.password_versions,       b.ctime,       b.password,       b.spare4 pswd_hashes

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center