按先后顺序执行一下操作即可完成用户的创建
-- 建临时表空间
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;
网友评论