oracle如何新建账号密码ORACLE创建表空间、用户、授权

1、创建表空间

create tablespace TESTloggingdatafile 'e:\app\administrator\oradata\orcl\TEST.dbf'size 100Mautoextend onnext 100M maxsize 4096Mextent management local;

2、创建用户并指定表空间

create use testuser identified by oracle账号passworddefault tablespace TESTtemporary tablespace temp;

3、授权

grant connect  to testuser;grant dba to testuser;grant role to testuser;