Oracle创建表空间和用户

奋斗的新丁

已于 2022-08-15 14:17:12 修改

阅读量440

点赞数 1

文章标签： oracle 数据库

于 2022-07-27 08:53:20 首次发布

本文链接：https://blog.csdn.net/qq_42374233/article/details/126007078

版权

--表空间
CREATE TABLESPACE ts_fams
DATAFILE '/data/orcl/ts_fams.dbf' size 800M
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 
--索引表空间
CREATE TABLESPACE ts_fams_idx
DATAFILE '/data/orcl/ts_fams_idx.dbf' size 512M         
         EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;     
 
--2.建用户
create user fams identified by fams
default tablespace ts_fams;
 
--3.赋权
grant connect,resource to fams ;
grant create any sequence to fams ;
grant create any table to fams ;
grant delete any table to fams ;
grant insert any table to fams ;
grant select any table to fams ;
grant unlimited tablespace to fams ;
grant execute any procedure to fams ;
grant update any table to fams ;
grant create any view to fams ;