ORACLE: User Creation and permission assignment (default account)

The following database version is Oracle 9i (9.2.0). When the database is installed, the database system creates a database instance. The installation directory is/Oracle, enter the Database Name and database SID number ora9i.

1. parameter settings during Database Installation

The following database version is Oracle 9i (9.2.0). When the database is installed, the database system creates a database instance. The installation directory is/Oracle, enter ora9i for both the Database Name and database Sid. the character set must be zhs16gbk (otherwise, it will be difficult to perform Chinese operations in the future ).

2. Database User Creation and permission allocation

After the database is installed, there are two system-level users:

1. the default system password is Manager.

2. The default sys password is change_on_install.

Find the sqlplus program in/Oracle/product/9.2/bin in the installed database directory and run:./sqlplus system/manager @ ora9i

Use the System user to create your own users and permissions. The SQL statement is as follows:

1. Create a user:

Create User Username identified by PWD default tablespace users temporary tablespace temp;

2. user authorization

Grant connect, resource, DBA to business;

3. Submit

Commit;

3. Use a database script to create a database

As described above, use sqlplus to log on as a username user and enter @ to create the database Script Name. SQL enter to create tables, views, and stored procedures in the database.

Note: The above user creation process allows the user's table to have n multiple temporary tables automatically generated by the system.