Monday, August 18, 2008

Drop all Oracle users created in the last year

select 'drop user '||username||' cascade;' from dba_users where created > sysdate -365;