java创建oracle用户_oracle数据库创建用户，并且给用户授权

参考文档：

http://www.blogjava.net/wolfman09/archive/2009/05/01/268536.html

一：创建用户

create user username identified by password;

二：给用户授权

GRANT

CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,

ALTER ANY TABLE, ALTER ANY PROCEDURE,

DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,

SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE

TO username;

三：当向表里插入数据，会包没有权限操作表空间users

解决方法：  alter user username QUOTA unlimited ON users TEMPORARY TABLESPACE temp;

四：删除用户

drop user username cascade;