Oracle: Create New User

Create Oracle schema goweekend
1. First verify name conflicts

SQL> select * from dba_users where username = 'GOWEEKEND';

SQL> CREATE USER GOWEEKEND IDENTIFIED BY think4ME DEFAULT TABLESPACE USERSPACE TEMPORARY TABLESPACE temp;

GRANT CREATE TABLE TO GOWEEKEND;
GRANT CREATE PROCEDURE TO GOWEEKEND;
GRANT CREATE SESSION TO GOWEEKEND;
GRANT CREATE VIEW TO GOWEEKEND;
GRANT RESOURCE TO GOWEEKEND;

select * from dba_role_privs where grantee = 'GOWEEKEND';
select * from dba_tab_privs where grantee = 'GOWEEKEND';
select * from dba_sys_privs where grantee = 'GOWEEKEND';