Re: Oracle automatically creates new users every day?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 1 Aug 2002 17:24:01 +1000
Message-ID: <Pe529.50073$Hj3.149690@newsfeeds.bigpond.com>

Hi Wailakig,

You've got to admit, Internetmaster's advice was pretty good :)

May I suggest the best way to stop it is to find out how (and more to the point why) exactly this is happening. Note that Oracle doesn't create users on it's own (suggestions that there is a Catholic version of Oracle are totally unfounded), there must be something running CREATE USER yetanotherone ... from somewhere.

Look in DBA_USERS to verify that in fact there are a whole bunch of users, use perhaps logminer to determine how they're being created.

Can't help thing 'why' is the most curious question though ...

Good Luck

"wailakig" <wailaki_at_batnet.com> wrote in message news:363c6009.0207311401.648de823_at_posting.google.com...
> I have some cororkers who run a server package on Oracle 9i on
> windows, and possibly 8i or 9i on Solaris); they say that Oracle is
> creating a new user every single day, on its own.
>
> Does anybody know how to stop it?
Received on Thu Aug 01 2002 - 02:24:01 CDT