oracle创建用户及权限

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

xcLeigh

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

阅读量916

点赞数

分类专栏：数据库使用文章标签： oracle 创建用户

BY xcSharp@126.com

本文链接：https://blog.csdn.net/weixin_43151418/article/details/102459691

版权

数据库使用专栏收录该内容

16 篇文章 1 订阅

订阅专栏

–临时表空间

create temporary tablespace TEMPQJWY  
tempfile '/home/oracle/app/oracle/oradata/orcl/TEMPQJWY.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local;

–表空间

create tablespace QJWYEM datafile '/home/oracle/app/oracle/oradata/orcl/QJWYEM.dbf' 
size 100M reuse autoextend on next 40M maxsize unlimited default storage(initial 128k next 128k minextents 2 maxextents unlimited);

–创建用户及赋权限

-- Create the user 
create user QJWYEM identified by QJWYEM
  default tablespace QJWYEM
  temporary tablespace TEMPQJWY
  profile DEFAULT;
-- Grant/Revoke role privileges 
grant connect to QJWYEM with admin option;
grant dba to QJWYEM;
grant resource to QJWYEM with admin option;
-- Grant/Revoke system privileges 
grant unlimited tablespace to QJWYEM with admin option;