怎么用语句创建用户?
我刚刚才开始学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;