Re: list users

From: David Vanidour <dvanidou_at_psc-cfp.gc.ca>
Date: 1998/02/17
Message-ID: <34EA0201.6D36@psc-cfp.gc.ca>#1/1

Ed Lufker wrote:
>
> Hi All:
>
> What commands would I use to list all the users in the database???
>
> thanks in advance
>
> eddie lufker

Depends on the information you are interested in Eddie.

Query 'dba_users', 'dba_tab_privs', 'dba_sys_privs', 'dba_profiles', 'dba_roles' and 'dba_role_privs' as a place to start.

Hope that helps.

ps. Oh and if your database doesn't give you the kind of information you are looking for from those, try 'user_???' instead.

Cheers. Received on Tue Feb 17 1998 - 00:00:00 CST