Create a user in Oracle using GRANT statement

If you would like to create a user, we generally use the following syntax.

CREATE USER SCOTT1 IDENTIFIED BY TIGER1;

Once the user is created the privileges list will be empty and hence we wont be able to log in to the schema. In order to be able to lo-gin we need to explicity grant certain privileges as shown

Grant Create Session, Resource to SCOTT1;

There is a combined syntax available. You can now create a New User with the GRANT Statement as shown below.

GRANT Create Session, Resource to SCOTT1 identified by TIGER1;