SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Windows ORA-1031: Insufficient Privileges While Connecting As SYSDBA

user12251389May 4 2016 — edited May 4 2016

I dont have grant permission for DBMS_CRYPTO. Now to give grant permission i need to

connect sqlplus as sysdba

and then granted permission as :

grant execute on sys.dbms_crypto to myuser;

But when i tried to connect as sysdba then i am getting error as `ORA-1031: Insufficient Privileges While Connecting As SYSDBA`. I search on this issue and seen i have to set ORACLE_SID but dont know my oracle SID and how to set it correctly otherwise it might create problem to my oracle installation.

This post has been answered by Jarkko Turpeinen on May 4 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 1 2016

Added on May 4 2016

5 comments

1,698 views