Create users of Oracle user Scott identified by Tiger;

Sqlplus on the command line.

Log in as system, password is the system you set

C:\users\administrator>sqlplus


Sql*plus:release 10.2.0.1.0-production on Tuesday October 14 21:29:23 2014


Copyright (c) 1982, 2005, Oracle. All rights reserved.


Please enter user name: System
Enter Password:


Connect to:
Oracle Database 10g Express Edition Release 10.2.0.1.0-production

After creating the user Scott password for tiger

Sql> create user Scott identified by Tiger;


The user has created.

Granting logon rights
Sql> Grant create session to Scott;


Authorization is successful.

Grant permission to create a table
Sql> Grant CREATE table to Scott;


Authorization is successful.

assigning quotas

sql> Alter user Scott quota 10m on users;


The user has changed.

Modify User Password

Alter user username identified by new password

Unlocking the user

Alter user Scott account unlock

Log on PL/SQL

Scott/tiger

Build table

CREATE TABLE UserInfo (
ID number,
Name varchar (20),
Age Number
)

ora-01950: No permissions on tablespace ' SYSTEM '

C:\users\administrator>sqlplus


Sql*plus:release 10.2.0.1.0-production on Wednesday October 15 07:53:13 2014


Copyright (c) 1982, 2005, Oracle. All rights reserved.


Please enter user name: System
Enter Password:


Connect to:
Oracle Database 10g Express Edition Release 10.2.0.1.0-production


Sql> Grant Connect,resource to Scott;


Authorization is successful.


Sql>

Create users of Oracle user Scott identified by Tiger;