Re: list users

From: ctcoryea <ctcoryea_at_ix.netcom.com>
Date: 1998/02/17
Message-ID: <01bd3b45$fb19dbc0$01c8c8c8@coryeasrv1>#1/1

Try: select * from all_users;

Can also query dictionary view dba_users. Do a describe on those views to choose specific select columns (eg username)

If you want current logged-on users, look at v$sessions view.

Chuck Coryea

---

remove xxxx in reply address Received on Tue Feb 17 1998 - 00:00:00 CST