Re: DBA_USERS

From: <bpage_at_kimball.com>
Date: 1998/05/20
Message-ID: <6jvdhg$ejr$1@nnrp1.dejanews.com>#1/1

In article <3562e000.0_at_per-nts1>,
"Linda Harte" <Linda.Harte_at_peregrine.ie> 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
>
>

desc all_users

 Name                            Null?    Type
 ------------------------------- -------- ----
 USERNAME                        NOT NULL VARCHAR2(30)
 USER_ID                         NOT NULL NUMBER
 CREATED                         NOT NULL DATE

Showing the password to users is not of much value, since it is encripted.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 20 1998 - 00:00:00 CDT