1 Oracle CREATE USER

-- USER SQL

CREATE USER zerock IDENTIFIED BY "zerock"  

DEFAULT TABLESPACE "USERS"

TEMPORARY TABLESPACE "TEMP";

-- QUOTAS

-- ROLES

GRANT "CONNECT" TO zerock ;

GRANT "RESOURCE" TO zerock ;

ALTER USER zerock DEFAULT ROLE "CONNECT","RESOURCE";

-- SYSTEM PRIVILEGES