Re: Help! New administrator needs hints on dropping users...

idmrmb_at_gsusgi1.gsu.edu (Pywacket) writes:

>Hello.
> I am new to admin for SQL. We are running Oracle 6 for Netware
>in our environment. It was acquired to provide hands-on experience
>for students taking both grad and undergrad classes in database.
>Now that the first quarter is over with, I need to delete/drop all
>of those students and everything they left laying around. I can't
>really get rid of the entire database and start from scratch because
>some researchers are using the same instance. How do I go about this?
>Is there an export utility that exports and then deletes? Do I have to
>create massive SQL syntax files to delete each and every object? And
>finally, is there a precedence to dropping a user's objects?
 

>Hopefully yours,
> Mark...
>
>--
>Mark Buffington / idmrmb_at_gsusgi1.gsu.edu / Ga State Univ / DBA Group

   What I did for my class is to create a separate tablespace    for the semester. I called it SPRING_93. All student stuff goes in    there and it fits in one physical file. End of Spring semester,    the tablespace can be dropped (I have not done this yet) and the    datafile removed.

   In your case, I would recommend moving the faculty and other long term    projects over to other tablespaces. This can also aid security.

   If either of these don't appeal to you, do as the other poster    suggested and DROP all of their tables then REVOKE all of    their privilidges. The user names still remain on the    list, they just have no privilidges.

Rich Holowczak
Rutgers University
holowcza_at_andromeda.rutgers.edu Received on Tue Jun 29 1993 - 04:51:18 CEST