Re: Q:Drop Users...

From: Lando <Markl_at_plant.pnwss.com>
Date: 1997/01/22
Message-ID: <01bc07ea$f8551b00$2a868cc6@quebim.quebim>#1/1

Earvin C. Lim <earvin_at_omega.uta.edu> wrote in article <5c35md$80i_at_news.uta.edu>...
>
> Hello All,
>
> When we drop users, if there are objects associated with the users, will
> the objects be deleted also? Or we have to delete it manually?
> Thanks in advance!
>
> --
> Earvin Lim
> -- Programmer/Analyst
> -- Academic Computing Services
> -- University of Texas at Arlington
> email: earvin_at_omega.uta.edu
> Phone: (817)272-3678
>

Use:

SQL> drop user YourUserName cascade;

To drop the user and all of their objects.

M.Landa Received on Wed Jan 22 1997 - 00:00:00 CST