Re: deleting all database objects belonging to a user
From: Brian Graham <GrahamB_at_psac.com>
Date: 1995/11/27
Message-ID: <49cfqe$iok_at_nic.ott.hookup.net>#1/1
Date: 1995/11/27
Message-ID: <49cfqe$iok_at_nic.ott.hookup.net>#1/1
In article <MSGID_2=3A240=2F5840.3=40fidonet_be98ea08_at_fidonet.org>, Karl_Regel_at_p3.f5840.n240.z2.fidonet.org (Karl Regel) says:
>
>+++ rsz # aifbodette.aifb.uni-karlsruhe.de_at_2:240/5889
>+++ "deleting all database objects belonging to a user"
>r> how can I delete (drop) all database objects belongig to a
>r> certain user in a simple way
>
>Simple : drop user xyz cascade ;
>und wech isser !
>
Under Oracle 6 you had to connect to the user and build a script file with the drop statements with a script selecting from tab.
-- BrianReceived on Mon Nov 27 1995 - 00:00:00 CET