Re: Oracle7 userids
From: Kathy Jou <kjou_at_us.oracle.com>
Date: Wed, 2 Sep 1992 17:12:36 GMT
Message-ID: <1992Sep2.171236.25868_at_oracle.us.oracle.com>
Date: Wed, 2 Sep 1992 17:12:36 GMT
Message-ID: <1992Sep2.171236.25868_at_oracle.us.oracle.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 ?
>
You can really get rid of a user with:
DROP USER scott;
or
DROP USER scott cascade; /* drop user and all objects */
- Kathy Jou
- Oracle Corp
- Disclaimer: just my own opinion, not Oracle's.