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

?

1 2 3 4 5 6

创建表空间 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