oracle 创建表空间和分配用户权限

CREATE TEMPORARY TABLESPACE drassh_temp
TEMPFILE 'E:\oracle\product\10.2.0\oradata\orcl\drassh_temp.dbf'
SIZE 32m
AUTOEXTEND ON;

CREATE TABLESPACE drassh
LOGGING
DATAFILE  'E:\oracle\product\10.2.0\oradata\orcl\drassh.dbf'
SIZE 32m
AUTOEXTEND ON;


CREATE USER drassh IDENTIFIED BY drassh1642
DEFAULT TABLESPACE drassh
TEMPORARY TABLESPACE drassh_temp;

GRANT CREATE SESSION,UNLIMITED TABLESPACE ,RESOURCE TO drassh