Re: Everyone can log on as sysdba on oracle 8i??????

Thanks all...

The problem was indeed that the UNIX user had dba rights. Solved i now. Thanks,

Cihat

c.genc_at_interpay.nl (Cihat) wrote in message news:<75fbbd1e.0208010149.7d4a236d_at_posting.google.com>...
> Hi,
>
> I have a weird situation here. I have an oracle 8i on a
> Unix (aix) machine. There are a total of 6 users in the password file
> (thats the result i get when i do a select on v$pwfile_users),
> two of them are sys and internal. When I create a user like this:
> 'create user test identified by test' it is possible to logon to the
> database with test as sysdba?! It also doesn't matter what i fill in
> as a password, it connects?! How is this possible? How can I deny normal
> users to log on as sysdba and how can I change the password of sysdba?
>
> thanks,
> Cihat
Received on Wed Aug 07 2002 - 03:37:19 CDT