oracle 12c 建立用户--避免ORA-65096 or ORA-65049错误.md

select sys_context ('USERENV', 'CON_NAME') from dual;
---通过ALTER SESSION SET CONTAINER 指定其他容器
---查看容器
select con_id,dbid,NAME,OPEN_MODE from v$pdbs; 
---将Pdb open：
alter pluggable database pdborcl open;
--切换容器到pdb
alter session set container=PDBORCL;
---查看当前使用容器
select sys_context ('USERENV', 'CON_NAME') from dual;

-- 创建表空间(invest_fund_client)  
create tablespace invest_agile_dev    
logging    
datafile 'D:\oracle12\oradata\orcl12\invest_agile_dev.dbf'   
size 50m  
autoextend on    
next 10m maxsize 400m  
extent management local;  
-- 创建用户并指定默认表空间(用户名：invest_fund_client 密码：invest_fund_client)  
create user invest_agile_dev identified by invest_agile_dev    
default tablespace invest_agile_dev;  


grant dba to invest_agile_dev; 
GRANT connect TO invest_agile_dev;
GRANT RESOURCE TO invest_agile_dev;
GRANT CREATE ANY sequence TO invest_agile_dev;
grant create session to invest_agile_dev;--授予zhangsan用户创建session的权限，即登陆权限
grant create table to invest_agile_dev;--授予创建表的权限
grant drop any table to invest_agile_dev;--授予删除表的权限

---回收unlimited tablespace权限
REVOKE UNLIMITED TABLESPACE FROM invest_agile_dev;