Re: Dropping Users?

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 username CASCADE will drop the user and the objects in the users schema. Referential integrity constrains on tables in other schemas will also be dropped.
Snapshots and roles the user has created will not be dropped. You have to drop these with DROP SNAPSHOT snapshot and DROP VIEW view.

--
Jan Ove Busklein                 PHONE     +47-73-594614
SINTEF Geotechnical engineering  FAX       +47-73-595340
N-7034 Trondheim                 TELEX     55620 sintf n
NORWAY                           INTERNET  Jan.Ove.Busklein_at_geotek.sintef.no