"drop user username cascade;" gets rid of all objects owned by a user along
with the user.
--
Dave A
"Thanh Nguyen" <Thanh.Nguyen_at_dnr.qld.gov.au> wrote in message
news:VutF5.45$gD.2789_at_nsw.nnrp.telstra.net...
> Would someone tell me please, that after a user is dropped (deleted),
would
> all objects belonging to this user be deleted off the database as well or
> they are still hanging there somewhere in the database occupying space,
just
> are not connected to any scheema ?
> Thank you
>
>
Received on Thu Oct 12 2000 - 21:46:59 CDT
