Re: delete a user with his tables, and everything

From: Tommy Yuen <yuent_at_hk.super.net>
Date: Wed, 15 Jul 1998 14:26:33 +0800
Message-ID: <6ohhss$qpm$1@tst.hk.super.net>

You can do this by:

DROP USER USERNAME CASCADE; It will drop all the tables, views, seq. etc.

Tommy

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 Wed Jul 15 1998 - 01:26:33 CDT

This message: [ Message body ]
Next message: Sylvain Leclerc: "Help with pl/sql cartridge under OWAS3.0"
Previous message: Ronnie Braverman: "Irix: n32 vs o32 linking"
In reply to: kvabg_at_ttacs1.ttu.edu: "delete a user with his tables, and everything"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US