> -----Original Message-----
> From: james ellis [mailto:[EMAIL PROTECTED]]
>
> connect as sys or system.
> drop user "username" cascade;
> The user and all objects will be removed.
>
> --- Mujeeb Chowdhry <[EMAIL PROTECTED]> wrote:
> >
> > How can I drop schema (user and all it's objects). I
> > have one main user in the application and wants to
> > drop user and all related objects. Can anyone help
> > me in this regard.
In My Humble Opinion, connecting as sys or system should be reserved for tasks that cannot be accomplished through another user.
Instead, you could connect as any user that has DBA role (or the appropriate privileges) and then issue the drop statement.
Also, it can often prove useful later to first do an export of the user and all the objects owned by that user, BEFORE doing the drop user cascade.
------
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.
http://www.quest.com
