Re: Help needed with deregistering students

In article <1992Jun22.142827.5875_at_infonode.ingr.com>, tensmekl_at_infonode.ingr.com (Kermit Tensmeyer) writes:
|> In article <17848.2a45efb8_at_levels.unisa.edu.au> ccspr_at_levels.unisa.edu.au writes:
|> >Can anyone help with a method of deregistering student users at the end of the
|> >year which also gets rid of their forms, menus etc?
|> >
|> >We have ORACLE installed on a Sun SPARCstation. Our SYSTEM tablespace is
|> >clogged with student work from year's back, and is continually needing extra
|> >database files.
|> >

you are not alone ...

|> gee, you seem to have a real problem and there isn't a simple answer.
|>
|> When you have solved the problem, may I suggest that next year for
|> you students that you add a new tablespace and grant your users
|> access and resource on _that_ tablespace. At the end of the year you
|> would be able to export the users who need to remain and drop the tablespace.
this fails because any use of the Oracle Tools will have left records in the tools tables in the system tablesapce (Forms, Menu, Case etc ..)
|>
|> As for the current users, I would first determine whose data needs to
|> be reatained and export those users first. Then Wipe Out the DataBase
|> and Recreate it. Add multiple tablespaces and assign users to the tablespaces
|> and alter the user accounts so that you don't allow them to write to
|> the system tablespace areas.

(what we do). It also has the advantage that say the first year can not grab all the space before the third year get round to working. Some years (eg third) requre more data security than others.

|>
|> Oracle doesn't allow you to delete users from the system, so you may
|> want to allow student accounts to be reusable.

what a pain !!

|>
|> Oh yes you can query the system tables to find tables that the user may have
|> owned and those table can be dropped from the tablespace. Deleting user
|> rows from forms tables, menu tables is also possible.
|>
So I suspect what all us academic instution users really are asking is :-

Has anyone written an "oblitterate user" script that removes all traces of this user (except the username).

If so will a kind soul post it please, if nothing else we can crib it for constructing our own.

Thanks.

-- 
RICK DIPPER, Unix Systems Administrator                       rick_at_uk.ac.man.cs
Department of Computer Science, University of Manchester           061-275-5725
.............................Meemberrr the of Fumblee Ingers Culb..............