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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Granting sysdba to a user

Re: Granting sysdba to a user

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Tue, 27 Jun 2000 11:32:56 +0300
Message-Id: <10541.110507@fatcity.com>


> What should i do to grant SYSBDA to user created .
> Now its failing with the following error ,
>
> ORA-01994: GRANT failed: cannot add users to public password file

try adding

REMOTE_LOGIN_PASSWORDFILE=exclusive

in your initXXX.ora file and restart the instance

hope this helps,

    Marin


"The important thing for all of us is never look *at* the bars, look *through* them. Because if you keep looking *at* bars, you'll never get anything done, and you'll never have fun in life, any joy."

                                                  William Wharton, "Pride"
Received on Tue Jun 27 2000 - 03:32:56 CDT

Original text of this message

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