Oracle 创建用户语句

最新推荐文章于 2024-07-18 17:34:08 发布

hunhun1122

最新推荐文章于 2024-07-18 17:34:08 发布

阅读量1.3k

点赞数

分类专栏： Oracle OracleDBA

本文链接：https://blog.csdn.net/hunhun1122/article/details/77988589

版权

Oracle 同时被 2 个专栏收录

75 篇文章 1 订阅

订阅专栏

OracleDBA

70 篇文章 8 订阅

订阅专栏

CREATE TABLESPACE TBS_FZJJ_BB_DATA
DATAFILE '+ORADATA' size 2048M
AUTOEXTEND on next 100m maxsize 8192m
EXTENT MANAGEMENT LOCAL autoallocate
SEGMENT SPACE MANAGEMENT AUTO;

--index file ASM:
CREATE TABLESPACE TBS_FZJJ_BB_IDX
DATAFILE '+ORADATA' size 1024M
AUTOEXTEND on next 100m maxsize 4096m
EXTENT MANAGEMENT LOCAL autoallocate
SEGMENT SPACE MANAGEMENT AUTO;

--create db user:
create user FZJJ_BB identified by FZJJ_BBADMIN
default tablespace TBS_FZJJ_BB_DATA temporary tablespace TEMP profile DEFAULT;

-- Grant/Revoke role privileges:
grant connect,resource,create database link,create synonym,create view,unlimited tablespace,debug connect session,select any dictionary,debug any procedure to FZJJ_BB;