Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: create a sysdba user question
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
![]() |
![]() |