Re: Drop a user

In our last gripping episode Inna <mednyk_at_my-deja.com> wrote:
> In article <92c2l4$n55$1_at_nnrp1.deja.com>,
> No Wonder <manyingsek_at_yahoo.com> wrote:
> > Hi,
> >
> > What's the proper way to drop a DB user??
> >
> > When the user is dropped, do I have to manually delete all those
> > tables/object of that user or it's done automatically by the server?
> >
> > Thanks,
> > Johnny
> >
> > Sent via Deja.com
> > http://www.deja.com/
> >
>
> When you drop user(schema) you drop everything that is inside of it
> That means all objects that user owned, including tables,
> functions,views: everything.
> --
> Inna.Junior programmer.
>
> Sent via Deja.com
> http://www.deja.com/
>

I believe you mean drop user <username> cascade. And, yes, when you issue a drop user <username> cascade you do drop all objects owned by that user.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com
http://www.deja.com/