Oracle user creation and permission assignment

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.