Re: Oracle7 userids

From: <dlm_at_hermes.dlogics.com>
Date: 3 Sep 92 11:14:24 CST
Message-ID: <1992Sep3.111424.1302_at_hermes.dlogics.com>


In article <1992Sep1.161828.337_at_hhcs.gov.au>, pihlab_at_hhcs.gov.au writes:
>
> Under Oracle6 when you revoke all access for a user there is no easy
> way of actually removing them completely from the database ie they still
> appear in the DBA_USERS table as a valid but inactive user.
>
> Has this changed under Oracle7 ?
>
Yes, in V7 you have the syntax DROP USER name CASCADE; which kills off the user's objects and all records of the userid.

--
Dave Mausner, Senior Consultant / Datalogics Inc / Chicago IL / 312-266-4450
dlm_at_dlogics.com                                 Motto: Just show me the code
Received on Thu Sep 03 1992 - 19:14:24 CEST

Original text of this message