windows drop em

maojinyu發表於2011-02-16
Windows
DECLARE
CURSOR c1 IS
SELECT owner, synonym_name name
FROM dba_synonyms
WHERE table_owner = 'SYSMAN';

BEGIN
FOR r1 IN c1
LOOP
IF r1.owner = 'PUBLIC' THEN
EXECUTE IMMEDIATE 'DROP PUBLIC SYNONYM '||r1.name;
ELSE
EXECUTE IMMEDIATE 'DROP SYNONYM '||r1.owner||'.'||r1.name;
END IF;
END LOOP;
END;


DROP ROLE mgmt_user;
drop user mgmt_view cascade;
drop user sysman cascade;[@more@]

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/9907339/viewspace-1046072/，如需轉載，請註明出處，否則將追究法律責任。

相關文章