Oracle user identity authentication method

Source: Internet
Author: User
Database identity authentication is easy to understand, that is, the Database User Password is stored in the database in an encrypted manner. When a user connects to the database, the user name and password must be entered.

Database identity authentication is easy to understand, that is, the Database User Password is stored in the database in an encrypted manner. When a user connects to the database, the user name and password must be entered.

Database Identity Authentication

Database identity authentication is easy to understand, that is, the Database User Password is stored in the database in an encrypted manner. When a user connects to the database, the user name and password must be entered, you can log on to the database only after passing database authentication. For example, to create a database authenticated user, the statement is:

SQL> create user hxy4 identified bysys123; // use the by keyword to determine that the authentication method is database identity authentication.

User created.

Therefore, the database must be in the open state.

External Identity Authentication

)

When a user tries to establish a connection to the database, the database does not require the user to enter the password and User Name

-- If you use external authentication to create a user account, Oracle delegates the authentication to the external service. It does not prompt for a password. If you enable the Advaned Security option, the only way to use external authentication is operating system authentication. This technology uses the same name as the operating system user account to create an Oracle user account, but adds the string specified by the OS _AUTHENT_PREFIX instance parameter before. By default, this parameter is an OPS $ string. You can use the following statements to query:

SQL> show parameter OS _authent_prefixNAMETYPEVALUE ------------------------------------------- ---------------------------- OS _authent_prefixstringops $ SQL> or: SQLVALUE limit ops $

Creating an external operating system authentication user is simple. If an operating system username is dragon, then:

For LINUX systems: create user ops $ dragon identified externally; for WINDOWS systems, if the login ID is Dragon, the domain name is MIS: create user "OPS $ MIS \ DRAGON" identified externally;

After creating a user, log on to the operating system as a dragon user, and then directly enter sqlplus/to log on and connect to the database.

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.