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