日期:2014-05-17  浏览次数:20826 次

怎么用语句创建用户?
我刚刚才开始学oracle,请问一下怎么用SQL语句来创建用户呢?急!!!!!

------解决方案--------------------
创建用户:
create user username identified by password
default tablespace tablespace_name
temporary tablespace temp
quota unlimited on tablespace_name;

授权:
grant connect,resource to username;
------解决方案--------------------
创建用户:
create user username identified by password
default tablespace tablespace_name
temporary tablespace temp
quota unlimited on tablespace_name;

授权:
grant connect,resource to username;