Re: create a sysdba user question

From: Rainer Herbst <rherbst__at__rz.uni-potsdam.de>
Date: Tue, 17 Jun 2003 11:33:46 +0200
Message-ID: <3EEEE07A.20609@_rz.uni-potsdam.de>

Ana C. Dent wrote:

> apple wrote:
> 

>> First I use orapwd script to set sysdba password like this:
>> orapwd file=c:\oracle\ora92\dbs\orapwtest.pwd password=jackone entries=6
>>
>> and I create a sysdba user like this:
>> create user dba_user1 identified by jacktwo;
>> grant sysdba to dba_user1;
>>
>> ok...when I try to log in dba_user1 account and sysdba privilege,I find I
>> can use either 'jackone' or 'jacktwo' password!!why???
>>
>> connect dba_user1/jackone as sysdba is ok
>> connect dba_user1/jacktwo as sysdba is ok.......
>>
>>

> 
> for the exact same reason
> 
> connect / as sysdba -- will also succeed.
> 
> 

Your OS user is member of the dba group? Revoke this group membership and it should work as expected!

HTH!
Rainer Received on Tue Jun 17 2003 - 04:33:46 CDT