oracle 12c 创建能用navicat 远程登录的帐号

当前模式是在cdb模式，navicat工具能连接。sqlplus用下面账户也能连接。

查看当前模式，如果不是cdb，请切换。（上一篇有讲）
创建表空间
create tablespace my_space
datafile '/usr/local/yrm/oracle_data/my_space.dbf'
size 50M
autoextend on next 50m maxsize 2048m
extent management local;
创建临时表空间
create temporary tablespace my_space_temp
tempfile '/usr/local/yrm/oracle_data/my_space_temp.dbf'
size 32m
autoextend on next 32m maxsize 1024m
extent management local;
创建用户
create user c##my_user_1 identified by 123456 default tablespace my_space
temporary tablespace my_space_temp;

创建角色
create role c##myroles container = all;
grant dba to c##myroles container = all;
授权
grant c##myroles to C##MY_USER_1 container = all;
#grant connect,resource to c##myroles;
grant restricted session to c##myroles;
alter user c##MY_USER_1 account unlock identified by 123456;