Why is it possible to log on to the oracle database as sysdba and enter your username and password ?, Sysdbaoracle

Source: Internet
Author: User

Why is it possible to log on to the oracle database as sysdba and enter your username and password ?, Sysdbaoracle

This is actually a problem with oracle database authentication.
In the sqlnet. ora file

SQLNET. AUTHENTICATION_SERVICES = (CNT)

Change

SQLNET. AUTHENTICATION_SERVICES = (NONE)

That is, you cannot use the system authentication method.


Why can I log on to Oracle using the Connect as sysdba username and password ??

As sysdba is used to log on AS a system administrator. The username and password are ignored. Even if you use SQLPLUS/as sysdba, you can use it without a user name or password.

Is the password in oracle the same as the user name? But why can I log on to the ORACLE database using sys/sys as sysdba?

The profile can be used to set the password style, but it can be set to the same name as the user name by default;
In addition, the sys/sys as sysdba logon method generally uses the operating system authentication method, but does not verify the password. You can try it, just enter a password or simply do not enter the password. For example:
Sqlplus sys/123 as sysdba
Sqlplus/as sysdba
Run the show user command and you will see that all of them are sys users.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.