Skip to Main Content

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!

Difference between DBA and SYSDBA

EV259Oct 1 2014 — edited Oct 1 2014

Hi All,

What is the difference between these two DBA and SYSDBA.

I have the access to login to the Database server and connected to sqlplus.

SQL>conn sys / as sysdba;

Then granted the DBA role( I don't know the SYS user password)  to SCOTT user, as i have this user password. So that I can connect to database through SQL Developer.

From my laptop's sql developer, I am connecting to the database with SCOTT user and role as 'SYSDBA', it is throwing me the ORA - 01017 invalid username or password error.

Kindly suggest me, what I am doing wrong here.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2014
Added on Oct 1 2014
3 comments
9,527 views