31、oracle中创建表空间及用户授权
2018-10-25 本文已影响0人
小母牛不生产奶
按先后顺序执行一下操作即可完成用户的创建
-- 建临时表空间
create temporary tablespace UIMS_ORG_TEMP tempfile 'F:\SXF\oracledata\uims_org_temp.dbf' size 2048m autoextend on next 1024m maxsize 10240m extent management local;
-- 建表空间
create tablespace UIMS_ORG logging datafile 'F:\SXF\oracledata\uims_org.dbf' size 1048m autoextend on next 1024m maxsize 10240m extent management local;
-- Create the user
create user UIMS_ORG
identified by "UIMS_ORG"
default tablespace UIMS_ORG
temporary tablespace UIMS_ORG_TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to UIMS_ORG;
grant dba to UIMS_ORG;
grant resource to UIMS_ORG;
-- Grant/Revoke system privileges
grant execute any class to UIMS_ORG;
grant unlimited tablespace to UIMS_ORG;