Oracle drop用户,新增用户

2014-11-24 08:46:25 · 作者: · 浏览: 3
Oracle drop用户,新增用户
删除用户脚本:
Sql代码
drop user smh_msg cascade;
新增用户脚本:
Sql代码
create user username identified by "123456";
grant connect to username;
grant dba to username;
grant resource to username;
grant unlimited tablespace to username;
alter user username default role connect,dba,resource;