Re: Deleting unactive Oracle accounts

The Wombat (wombat_at_wimsey.com) wrote:

: In article <2qtsbf$kjv_at_acme.gatech.edu>, ccocsjm_at_prism.gatech.edu (Joe
: McKee) wrote:
 

: > In article <shatzmanCpJKCG.1EE_at_netcom.com> shatzman_at_netcom.com (bs) writes:
: > >kulvindar singh (ksingh_at_mach1.wlu.ca) wrote:
: > >: Does anyone have recommendations about the advisability of deleting obsolete
: > >: user accounts from the user$ dictionary table (Version 6 of Oracle). We are
 

: ++> Are you running a 6.0.36 or 6.0.37 database?? I have a script that
: walks
: ++> through the dictionary and the SGA and removes V6 users.
: ++> is this what you need? In V7 you can drop user cascade;

: > >: finding that these obsolete accounts are cluttering up the dba_users view.
: > >: Thanks for any help.
: >
: > You will also find that after adding your 32,767th user, you can
: > add no more.
: >
: >
: > --
: > Joe McKee
: > ccocsjm_at_prism.gatech.edu

--
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+      Christian Mondrup                                                      +
+      UNI-C Aarhus, Danish Computing Centre for Research and Education.      +
+      Olof Palmes Alle 38, DK 8200 Aarhus N.                                 +
+                                                                             +
+      Phone:   +45 86 78 44 44                                               +
+      Telefax: +45 86 78 44 55                                               +
+      E-Mail:  Christian.Mondrup_at_uni-c.dk                                    +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++