Oracle 创建表空间、用户、分权限

最新推荐文章于 2024-08-06 09:10:25 发布

编码行者

最新推荐文章于 2024-08-06 09:10:25 发布

阅读量117

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/mbh12333/article/details/110136171

版权

数据库专栏收录该内容

11 篇文章 0 订阅

订阅专栏

windows 环境

create tablespace c1_gdt_management_tbs datafile 'e:\oracledata\c1_gdt_management_tbs.dbf' size 1024m;
create user c1_gdt_management identified by c1_gdt_management default tablespace c1_gdt_management_tbs;
grant dba to c1_gdt_management;
grant create view,create session,resource,unlimited tablespace to c1_gdt_management;
alter user c1_gdt_management default role resource;

linux 环境

create tablespace mbhhbv2 datafile '/home/oracle/oracledata/mbhhbv2.dbf'  size 1024M autoextend on next 1024M maxsize unlimited logging extent management local autoallocate segment space management auto;
create user mbhhbv2 identified by mbhhbv2con default tablespace mbhhbv2 temporary tablespace TEMP profile DEFAULT;
grant dba to mbhhbv2;
grant create view,create session,resource,unlimited tablespace to mbhhbv2;
alter user mbhhbv2 default role resource;