1 2 3 4 5 6
|
select 'Drop user '||username||' cascade;' from dba_users
where username not in
('SYS','SYSTEM','OUTLN','DBSNMP','WMSYS','PERFSTAT','SYSMAN','XDB','TSMSYS','ORDSYS','OLAPSYS','MDSYS','EXFSYS','CTXSYS','DMSYS','OUTLN','DIP','ORACLE_OCM','APPQOSSYS',
'ANONYMOUS','ORDDATA','ORDPLUGINS','SI_INFORMTN_SCHEMA','MDDATA','SPATIAL_WFS_ADMIN_USR','SPATIAL_CSW_ADMIN_USR','FLOWS_FILES','APEX_PUBLIC_USER','APEX_030200','OWBSYS',
'OWBSYS_AUDIT','SCOTT','XS$NULL','AUDSYS','GSMADMIN_INTERNAL','GSMUSER','GSMCATUSER','SYSBACKUP','SYSDG','SYSKM','OJVMSYS','DVSYS','LBACSYS','DBSFWUSER','REMOTE_SCHEDULER_AGENT','DVF','PUBLIC'); |
Partager