借一个oracle账号Oracle10g平时常用到的sql整理

CREATE USER testuser1
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
GRANT create session,create table,
11
      create view
12
TO    manager;
13
 
14
GRANT managoracle账号er TO testuser1;
1
ALTER USER testuser1
2
IDENTIFIED BY testuser2;
1
DROP USER testuser1 cascade;

摘自 远在他乡的博客