首页 > 数据库 >Oracle创建表空间、创建用户以及授权

Oracle创建表空间、创建用户以及授权

时间:2022-12-08 14:58:11浏览次数:37  
标签:workflow 创建 CREATE 用户 USER jtj Oracle 授权

创建表空间
CREATE   TABLESPACE workflow_jtj  DATAFILE   '/home/oracle/app/oracle/oradata/helowin/workflow_jtj_space.dbf'  size 500m  AUTOEXTEND ON
创建用户并指定表空间
CREATE USER workflow_jtj IDENTIFIED BY trueway2022 DEFAULT TABLESPACE workflow_jtj;
授权用户
GRANT CREATE USER,DROP USER,ALTER USER ,CREATE ANY VIEW , DROP ANY VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE, DBA,CONNECT,RESOURCE,CREATE SESSION TO  workflow_jtj;

参考连接:https://cloud.tencent.com/developer/article/2103766?from=article.detail.2105788

标签:workflow,创建,CREATE,用户,USER,jtj,Oracle,授权
From: https://www.cnblogs.com/xiaoni-fighting/p/16966054.html

相关文章