Re: Dropping Users?

From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Wed, 7 Dec 1994 12:23:46 GMT
Message-ID: <James.Lawrence.54.000C65C9_at_epamail.epa.gov>


In article <cit90Te00iV1I1IBpf_at_andrew.cmu.edu> Janet Cohen <jc6n+_at_andrew.cmu.edu> writes:
>From: Janet Cohen <jc6n+_at_andrew.cmu.edu>
>Subject: Dropping Users?
>Date: Tue, 6 Dec 1994 11:23:59 -0500
 

>I'm in an academic environment where Oracle is used for teaching only.
>As network adminstrator, I installed and made sure Oracle is working,
>and I create the user accounts used for the database management class.
>That's the extent of my Oracle knowledge.
 

>At the end of each semester, I need to remove the student's Oracle
>accounts. I understand how to revoke their rights. But I cannot figure
>out from the manuals I have how to actually drop those accounts, PLUS
>any objects/links, or whatever they may have created. Can anyone help
>me?
 

>(The course instructor does not know how to administer Oracle.)
 

>Thanks,
> - Janet

DROP USER <user> CASCADE; will get rid of the user and any objects he/she owns.

Lawrence.... Received on Wed Dec 07 1994 - 13:23:46 CET

Original text of this message