Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Drop a user
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/Received on Wed Dec 27 2000 - 09:08:30 CST