Oracle
1.创建用户并制定表空间
CREATE USER user_test IDENTIFIED BY xxxxxxxxxxxx #创建user_test 用户 密码为xxxxxxxxxxxx
DEFAULT TABLESPACE TBS_ZBQDXP #用户表空间
TEMPORARY TABLESPACE ZBQDXP_TEMP;# 临时表空间
2.赋予用户权限
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 user_test
3.将role这个角色授予username,也就是说,使username这个用户可以管理和使用role所拥有的资源
GRANT role TO username;