用友NC创建表空间、用户、授权

QQ 361596962

于 2022-06-22 22:45:59 发布

阅读量865

点赞数 1

分类专栏：用友 NC NCC 文章标签： java 服务器前端

本文链接：https://blog.csdn.net/kyyh0386/article/details/125418128

版权

1、创建表空间

CREATE TABLESPACE NNC_DATA01 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_data01.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
CREATE TABLESPACE NNC_DATA02 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_data02.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M ;
CREATE TABLESPACE NNC_DATA03 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_data03.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M ;
CREATE TABLESPACE NNC_INDEX01 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_index01.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
CREATE TABLESPACE NNC_INDEX02 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_index02.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
CREATE TABLESPACE NNC_INDEX03 DATAFILE 'e:\app\Administrator\oradata\orcl\nnc_index03.dbf' SIZE 200M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;

2、创建用户

CREATE USER NC65 IDENTIFIED BY NC65 DEFAULT TABLESPACE NNC_DATA01 TEMPORARY TABLESPACE temp;

3、授权用户

GRANT connect,dba to NC65;