After Oracle database is established, user name and password are set up on Windows platform

Source: Internet
Author: User
Tags oracle database installation

In general, after the Oracle database installation, there are many default accounts and passwords, more commonly used are:

Account: Scott Password: Tiger account: System Password: Manager account: sys password: any character.

When we want to create an account, we can use SYS to login SYSDBA, create the user (need authorization), the code is as follows

1 2 3 4 5 Create user username identified by "password";                Authorization: Grant create session to user name;                Grant CREATE table to user name;                Grant create tablespace to user name;     Grant CREATE view to user name; Grant create sequence to user name;

Please enter user name: System
Enter Password:


Connect to:
Oracle Database 11g Enterprise Edition release 11.2.0.1.0-64bit Production
With the partitioning, OLAP, Data Mining and real application testing options

Sql> create user QC identified by "QC";
User has created.


Sql> Grant create session to QC;
The authorization was successful.


Sql> grant CREATE table to QC;
The authorization was successful.


Sql> Grant create tablespace to QC;
The authorization was successful.

Sql> Grant CREATE view to QC;
The authorization was successful.

Sql>grant create sequence to QC;

The authorization was successful.

You can then log on with the newly set user.

We typically use Scott to log in to Sysdba, at which point the account may not unlock the state, this time can be used

1 Alter user Scott account unlock;

To unlock the account. You may be asked to change the password after unlocking:

1 Alter user Scott identified by Tiger;

Login again

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.