Re: DBA_USERS

You can create a view based on DBA_USERS for your non DBAs. Remember you will have to grant select on DBA_USERS explicitly to the individual users for the view to work. It won't work if you grant it through a role.

Also, passwords are encrypted in the database, so none of them will be of any use to someone who is not a DBA.

Hope this helps.

Adrian

Linda Harte wrote:

> Is there a table or view that non-dba users have access to
> (read-only is just fine) that contains information about the
> username and password of users.
>
> Thanks in advance
> Linda
Received on Wed May 20 1998 - 00:00:00 CEST