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 -> create a sysdba user question

create a sysdba user question

From: apple <applechu_at_elifemall.com.tw>
Date: Tue, 17 Jun 2003 10:53:47 +0800
Message-ID: <bclvu0$s7l@netnews.hinet.net>


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....... Received on Mon Jun 16 2003 - 21:53:47 CDT

Original text of this message

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