After Oracle install forgot username or password + Create new login user

Source: Internet
Author: User

The newly installed oracle11g, unexpectedly in use when the user name and password is not remembered at the time of installation.

Don't worry, open the sqlplus.

Follow the steps below to create a new login user:

The first step: Log in with sys sys/Password as sysdba any character here can be logged on.

Sys/manager as Sysdba

Once the login is successful, you can create a new user.

Step Two:

Create user

Grammar:

Create user username identified by password create user admin identified by ORCL;

To unlock the user you just created: ALTER user Username account Unlock/lock

Alter user admin account unlock; User Unlocked

Alter user admin account lock; User Lock

Grant new logged on user Create permission

Syntax: GRANT CREATE SESSION to user name

Grant create session to admin;

Grant the newly created user database administrator rights

Grammar:

Grant DBA to User name; Grant dba to admin;

Switch to the newly created user login

Syntax: CONNECT user name/password

Connect ADMIN/ORCL;

Delete User

Syntax: DROP user username

Drop user admin;

Note that all actions must be added at the end of the ";" To perform successfully

Forget user name or password after Oracle installation + Create new login user

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.