Sample Oracle Create User SQL Script

A sample user creation script for Oracle

Drop user sample_user cascade;

CREATE USER sample_user IDENTIFIED BY sample_user_password
DEFAULT TABLESPACE USER_DATA
   TEMPORARY TABLESPACE user_temp
   PROFILE DEFAULT
   ACCOUNT UNLOCK;

GRANT "CONNECT" TO sample_user;
GRANT "RESOURCE" TO sample_user;
ALTER USER sample_user DEFAULT ROLE "CONNECT", "RESOURCE";
GRANT CREATE MATERIALIZED VIEW TO sample_user;
GRANT CREATE SEQUENCE TO sample_user;
GRANT CREATE SESSION TO sample_user;
GRANT CREATE SYNONYM TO sample_user;
GRANT CREATE TABLE TO sample_user;
GRANT CREATE TRIGGER TO sample_user;
GRANT CREATE VIEW TO sample_user;
GRANT UNLIMITED TABLESPACE TO sample_user;
PURGE RECYCLEBIN;