Cacher is the code snippet organizer for pro developers

-- list users
select * from dba_users;

--list tables
select table_name from user_tables;

-- create user
CREATE USER {username} IDENTIFIED BY "{password}" ;
GRANT unlimited tablespace TO {username};
GRANT create session TO {username};
GRANT create table TO {username};
GRANT create view TO {username};
GRANT create sequence TO {username};
GRANT create trigger TO {username};