Re: dropping all objects for an user

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_at_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
> >
> >
Received on Wed May 05 1999 - 19:38:18 CDT