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