Xref: alice comp.databases.oracle.server:48377
Path: alice!news-feed.fnsi.net!news.he.net!nntp.flash.net!news.flash.net!not-for-mail
Message-ID: <3730E619.3B7BB361@flash.net>
From: Al Ruiz <arruiz@flash.net>
X-Mailer: Mozilla 4.04 [en]C-NECCK  (Win95; I)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: dropping all objects for an user
References: <7fkgru$her$1@demon.uunet.ca> <372458f4@news.sto.telegate.se>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 27
Date: Thu, 06 May 1999 00:38:18 GMT
X-Complaints-To: abuse@flash.net
X-Trace: news.flash.net 925951098 38.30.171.74 (Wed, 05 May 1999 19:38:18 CDT)
NNTP-Posting-Date: Wed, 05 May 1999 19:38:18 CDT
Organization: FlashNet Communications, http://www.flash.net

The easiest way is to make note of the user priviledges, drop the user in
question, and recreate the user in question and grant the priviledges again...

Al Ruiz

Kjetil Nordstrand wrote:

> No, write a script that will loop thru USER_OBJECTS and get the cascading
> right.
>
> --
> Kjetil Nordstrand
> Karlstad, Sweden
>
> dfp1 skrev i meddelandet <7fkgru$her$1@demon.uunet.ca>...
> >Hi,
> >
> >Is there a SQL statement that will let me drop all the objects in an users
> >schema, but preserve the user (with privileges etc. intact)?
> >
> >Thanks,
> >Dinesh
> >
> >