CREATE USER testuser1IDENTIFIED BY testuser1;GRANT create session, create table,      create sequence,create viewTO    testuser1;CREATE ROLE manager;GRANT create session,create table,      create viewTO    manager;GRANT manager TO testuser1;

ALTER USER testuser1IDENTIFIED BY testuser2;

DROP USER testuser1 cascade;