Re: delete a user with his tables, and everything

From: Collin Leung <collinl_at_vtc.edu.hk>
Date: Tue, 14 Jul 1998 09:10:38 +0800
Message-ID: <6oeb7m$a0u@is1.vtc.edu.hk>

Syntax
DROP USER user CASCADE;

user is the user to be dropped.
CASCADE drops all objects in the user’s schema before dropping the user. You must specify this
option to drop a user whose schema contains any objects.

collin
;
kvabg_at_ttacs1.ttu.edu wrote in message <1998Jul13.101842_at_ttacs1>...
>Hi,
>I want to delete a user who owns a repository, tables, etc.
>How can I delete the user together with the tables, views, and all the
staff
>releted to him??
>
>Thanks
>Bulent Gumus
>bgumus_at_tis.eklly.af.mil
>
Received on Mon Jul 13 1998 - 20:10:38 CDT