CREATE USER demo IDENTIFIED BY demo; -- create user with password
GRANT CONNECT,RESOURCE,DBA TO demo; -- grant DBA,Connect and Resource permission to this user(not sure this is necessary if you give admin option)
GRANT CREATE SESSION TO demo WITH ADMIN OPTION; --Give admin option to user
GRANT UNLIMITED TABLESPACE TO demo; -- give unlimited tablespace grant