Re: Some questions

>1.) Is it possible for me to display all the tables created by a user?

select table_name from dba_tables where owner = '&owner';

>2.) Is it possible for me to show all the users who have logged in the
>server?

For current logins, see V$SESSION.
To see anyone who has ever logged in, you need to enable auditing. Set AUDIT_TRAIL = DB in init.ora, and enable auditing within the database (AUDIT CONNECT WHENEVER SUCCESSFUL;). You'll need to shutdown and restart the database for the init.ora change to take effect. Audit records will be inserted into SYS.AUD$, which you can access via the many "DBA_AUDIT" views. You'll need to manually delete the records from AUD$ so that table does not overwhelm the space in the SYSTEM tablespace.

hth.
Kevin
http://www.kevinloney.com Received on Wed Nov 11 1998 - 09:34:12 CST