Hi Stephen,

Sorry, I meant old users, that is, people who should no longer have
accounts. Problem is, this server is set up so that all users are
authenticated externally. We can't add another user and the Snr Unix
Administrator tells us, he cannot create any more accounts because we've hit
the 65,000 limit ( hard to believe).

Derek.


>From: "Karniotis, Stephen" <[Email Address Removed] 'Derek Nkansah' <[Email Address Removed] RE: Oracle 7.3
>Date: Thu, 28 Feb 2002 10:16:09 -0500
>
>I don't believe that the database has a limit. However, you can delete
>users by saying DROP USER username CASCADE and all goes away. Not sure
>what
>you mean by defunct users.
>
>Thank You
>
>Stephen P. Karniotis
>Technical Alliance Manager
>Compuware Corporation
>Direct: (248) 865-4350
>Mobile: (248) 408-2918
>Email: Stephen.[Email Address Removed] www.compuware.com
>
>
> -----Original Message-----
>From: Derek Nkansah [mailto:[Email Address Removed] Thursday, February 28, 2002 10:10 AM
>To: LazyDBA.com Discussion
>Subject: Oracle 7.3
>
>Hi,
>
>I know this might not be true but is it true that the capacity for 7.3 is
>65,000 users and that you cannot delete users from this??
>
>It sounds a bit ludicrous but then anything is possible. The sticking point
>is, can defunct users be deleted and if so, how?? Is there a special way or
>the usual "drop user" command??
>
>Please help!
>
>Derek
>
>
>_________________________________________________________________
>MSN Photos is the easiest way to share and print your photos:
>http://photos.msn.com/support/worldwide.aspx
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html




_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp.

Oracle LazyDBA home page