Re: Looping through the users table

set verify off
set head off
set pages 0
set echo off
set linesize 120
spool bye_moti.sql
select 'drop user '||username||' cascade;' from dba_users where username = 'MOTI';
spool off
@bye_moti

That's off the top of my head, so don't use it in the Voyager worm just yet.

jg

--


@home.com is bogus.

http://www.boston.com/business/globe/articles/2006/01/01/check_verification_system_is_vulnerable_to_mistakes/?rss_id=Boston.com+%2F+Business+%2F+Personal+Finance+-+Money+Management+-+Financial+Management+-+Boston.com