Re: Granting sysdba to a user

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