Oracle 创建表空间&建表授权

创建表空间

查询表空间地址

select name from v$tempfile;

create tablespace TP datafile 'D:\DB\Oracle\app\product\TBspacetp.dbf' size 200 m autoextend on next 10 m maxsize unlimited;

创建并授权用户

-- Create the user

create user TP_PFCT

default tablespace TP

IDENTIFIED BY "xxxxxxx"

temporary tablespace TEMP

profile DEFAULT;

-- Grant/Revoke role privileges

grant connect to TP_PFCT;

grant resource to TP_PFCT;

-- Grant/Revoke system privileges

grant create session to TP_PFCT;

grant delete any table to TP_PFCT;

grant execute any class to TP_PFCT;

grant execute any procedure to TP_PFCT;

grant insert any table to TP_PFCT;

grant select any dictionary to TP_PFCT;

grant select any sequence to TP_PFCT;

grant select any table to TP_PFCT;

grant select any transaction to TP_PFCT;

grant under any table to TP_PFCT;

grant under any type to TP_PFCT;

grant under any view to TP_PFCT;

grant unlimited tablespace to TP_PFCT;

grant update any table to TP_PFCT;

grant dba to tp_pfct;

grant select any table to tp_pfct;

删除用户

drop user tp_pfct cascade