Re: Deleting unactive Oracle accounts
Date: Sat, 14 May 1994 00:05:24 -0800
Message-ID: <wombat-140594000524_at_pme01.pomo.wis.net>
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
Received on Sat May 14 1994 - 10:05:24 CEST