Oracle Database Discussions

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SYS user not have SYSDBA privileges

Thetchinamoorthy GanesanJul 19 2011 — edited Jul 19 2011

Hi Experts,

Now I am facing new issue that, I can able to connect SYS user with different password as SYSDBA (password whcih is not register in passwd_file)

eg:

SQL> connect SYS/manager as SYSDBA;
Connected
SQL> connect SYS/welcome1 as SYSDBA;
Connected
SQL> connect SYS/asadafaf as SYSDBA;
Connected

keep on SYS user is connecting with unknown password in oracle DB.
please help me to resolve this issue

I have tried with following command to check SYS user have SYSDBA privileges or not.

select * from v$passwd_users;

and it returns "no rows selected", hope SYS user does not have SYSDBA privileges.
Please help me, how to reassign SYSDBA privileges to SYS user

Note: we have un-installed and installed Oracle 11g DB (ver 11.1.1.4) from linux machine still we are facing same issue.
Please help me ASAP, its an urgent

Thanks,
Phani

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 16 2011

Added on Jul 19 2011

#general-database-discussions

12 comments

3,400 views