oracle经验之谈

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;


上一篇 下一篇

猜你喜欢

热点阅读