Create an Oracle user createuserscottidentifiedbytiger;

Create an Oracle user createuserscottidentifiedbytiger;

Sqlplus in the command line

Log On As A system user. The password is your own system.

C: \ Users \ Administrator> sqlplus

SQL * Plus: Release 10.2.0.1.0-Production on Tuesday October 14 21:29:23 2014

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Enter the User name: system
Enter the password:


Connect:
Oracle Database 10g Express Edition Release 10.2.0.1.0-Production

Create the user scott and set the password to tiger.

SQL> create user scott identified by tiger;

The user has been created.

Grant logon permission
SQL> grant create session to scott;

Authorization successful.

Grant table creation permission
SQL> grant create table to scott;

Authorization successful.

Allocate quota

SQL> alter user scott quota 10 m on users;

The user has changed.

Change User Password

Alter user Username identified by new password

Unlock a user

Alter user scott account unlock

Log on to pl/SQL

Scott/tiger

Create a table

Create table userinfo (
Id number,
Name varchar (20 ),
Age number
)

Ora-01950: Table space 'system' has no permission

C: \ Users \ Administrator> sqlplus

SQL * Plus: Release 10.2.0.1.0-Production on Wednesday October 15 07:53:13 2014

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Enter the User name: system
Enter the password:

Connect:
Oracle Database 10g Express Edition Release 10.2.0.1.0-Production

SQL> grant connect, resource to scott;

Authorization successful.

SQL>