Re: Help! New administrator needs hints on dropping users...

Do this under each user:

set heading off pagesize 999 feedback off echo off

spool dr_tab.sql

select 'drop table '||tname||';'
from tab
where tabtype='TABLE';

spool off

You can then execute this SQL. I am not sure if the column is tabtype, table_type, tabletype, or tab_type. Just do a DESC TAB to get the answer.

Then as the DBA, do: revoke connect, resource to {username} Received on Tue Jun 29 1993 - 04:01:55 CEST