orcal操作锦级

上一篇 / 下一篇 2018-01-16 11:23:28 / 个人分类：oracle

sqlplus / as sysdba

--表空间

CREATE TABLESPACE sdt

DATAFILE 'E:\oracle\tablespace1' size 2000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

--索引表空间

CREATE TABLESPACE sdt_Index

DATAFILE 'E:\oracle\tablespace2' size 1000M

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

--建用户

create user test1 identified by test1

default tablespace sdt;

--赋权

grant connect,resource to test1;

grant create any sequence to test1;

grant create any table to test1;

grant delete any table to test1;

grant insert any table to test1;

grant select any table to test1;

grant unlimited tablespace to test1;

grant execute any procedure to test1;

grant update any table to test1;

grant create any view to test1;

TAG: