02
IDENTIFIED BY testuser1;
03
04
GRANT create session, create table,
05
create sequence,create view
06
TO testuser1;
07
08
CREATE ROLE manager;
09
10
11
create view
12
TO manager;
13
14
GRANT manager TO testuser1;
1
ALTER USER testuser1
2
IDENTIFIED BY testuser2;
1
DROP USER testuser1 cascade;
摘自 远在他乡的博客