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;