Re: What's the password for a role

Terry Dykstra wrote:
> I need to determine the password for a role. What sys table has that info?
The only public data dictionary table that holds information about roles is sys.dba_roles. (all_roles and user_roles do not exist). However sys.dba_roles does not contain any password info, except for a boolean flag that a password is required. The data dictionary view used by the SQL*Export uses sys.exu8rol to retrieve the crypted password.
The SQL*Import uses "CREATE ROLE ... IDENTIFIED BY VALUES ..." to set the crypted password (this option is undocumented). "ALTER ROLE" has the same possibility.
The passwords for users and roles are never stored in their original format, but a DBA can teporarily set a new password, and then restore the old password without even knowing the old password.

HTH,         E. Received on Fri Jun 15 2001 - 18:07:44 CDT