Re: Q:Drop Users...

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/26
Message-ID: <32EBEF72.57CE@qrcsun.qrc.org>#1/1

Earvin C. Lim wrote:
>
> 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?

You can use CASCADE option. If a user which will be deleted later without CASCADE option (but with schema object), an error will be returned.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

Received on Sun Jan 26 1997 - 00:00:00 CST