Oracle创建表空间及用户并授予权限

--查询用户表空间文件的路径
select name from v$datafile;

--创建表空间
create tablespace ruoyi datafile '/opt/oracle/app/oradata/orcl/ruoyi.dbf' 
size 2000M autoextend on next 32m maxsize 2048m extent management local SEGMENT SPACE MANAGEMENT AUTO;

--查看临时表空间文件的路径
select name from v$tempfile;

--创建临时表空间
create temporary tablespace RUOYI_TEMP  
tempfile '/opt/oracle/app/oradata/orcl/RUOYI_TEMP.dbf' 
size 50m  
autoextend on  
next 50m maxsize 20480m  
extent management local; 

--创建用户密码与上面创建的文件形成映射关系
create user ruoyi identified by ruoyi default tablespace ruoyi temporary tablespace RUOYI_TEMP;

--更改用户密码
alter user ruoyi identified by shenma;

--授权
grant connect,resource,dba to ruoyi;

--查询已创建的用户
select username from dba_users;