Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: create a sysdba user question

Re: create a sysdba user question

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 16 Jun 2003 20:04:18 -0700
Message-ID: <RyvHa.84568$MJ5.44055@fed1read03>


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. Received on Mon Jun 16 2003 - 22:04:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US