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

来源:互联网 发布:清退中部分租户接通知 编辑:程序博客网 时间:2024/05/16 18:08
CREATE TEMPORARY TABLESPACE drassh_tempTEMPFILE 'E:\oracle\product\10.2.0\oradata\orcl\drassh_temp.dbf'SIZE 32mAUTOEXTEND ON;CREATE TABLESPACE drasshLOGGINGDATAFILE  'E:\oracle\product\10.2.0\oradata\orcl\drassh.dbf'SIZE 32mAUTOEXTEND ON;CREATE USER drassh IDENTIFIED BY drassh1642DEFAULT TABLESPACE drasshTEMPORARY TABLESPACE drassh_temp;GRANT CREATE SESSION,UNLIMITED TABLESPACE ,RESOURCE TO drassh