By submitting your email address, you agree to receive emails regarding relevant topic offers from TechTarget and its partners. You can withdraw your consent at any time. Contact TechTarget at 275 Grove Street, Newton, MA.
How do I display all the users/schemas with a password from the Administrator? The results should display passwords in character form.
You can issue a query similar to the following:
SELECT username,password FROM dba_users;
However, the password is encrypted with a one-way hash algorithm. Since this algorithm is one-way, there is no way to decrypt the password.