Re: Oracle automatically creates new users every day?

one way may be to revoke DBA privs from everyone except yourself and add them back one by one until the miscreant is ID'ed..

pagesflames_at_usa.net (Dusan Bolek) wrote:

>"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<Pe529.50073$Hj3.149690_at_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 ...
>
>That's why I've asked fot their names. I have an idea that reason for
>this "automatic" creating of users is someone who is trying daily to
>run some admin scripts from ?/rdbms/admin and at the end of day some
>other "DBA" always deletes this users because do not know purpose of
>them.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Thu Aug 01 2002 - 11:53:48 CDT