Re: create a sysdba user question

To verify that everything is working, try to connect as SYSDBA from a *remote* device like your workstation, not the database server. You are signed on to the database server as a member of the 'dba' group (Unix) or ORA_DBA group (Windows) and can sign on with 'connect fud/foobar as sysdba' if you want to.

HTH,
Brian

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.......

-- 
===================================================================

Brian Peasland
oracle_dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"