Creating new a user (schema) on Oracle Database

Imagine you have sysadm access to the Oracle database and you need to create a new user with his own schema. You need to run just 2 queries:


CREATE USER username IDENTIFIED BY username //Create user "username" with password "username"
GRANT ALL PRIVILEGES to username // grant all privileged, so now you can connect and create your databases

Enjoy :)