How To Create a User/Schema On Oracle

dbtut

6 years ago

User and schema creation operations are the same in Oracle.

When you create a user, a schema is automatically created for the user.

Each user can create objects such as tables, views, functions, stored procedures under their own schema.

Users can authorize other users for these objects they create.

We can create a user on oracle using the following script.

CREATE USER myusername Identified By "mypassword";

1	CREATE USER myusername Identified By "mypassword";