Unable to login with sysdba rights on windows.

Hi all of you,

Here I am going to share some of the Oracle based queries which can be helpful to someone who is just starting with Oracle.

Well, first question most of the times is that how to connect a user as a sysdba. Normally we try to login with the System user but you should know that System user does not have this kind of Privilege from the start. So in order to start using sysdba privileges login with the sys user and connect it as sysdba. Password is normally same for sys also.

Once you have login with this user you can assign sysdba role to another user also using the following query.

Grant SYSDBA to username