多组户体系架构里的表空间管理，多组户体系架构里的安全性维护和备份恢复及统一审计和导入和导出，课程第70/71次（2017-03-25星期六晚上和2017-03-

botang · 发表于 2017-3-27 14:57:02

本帖最后由 botang 于 2017-3-27 15:02 编辑

上完1Z0-063第5章（多组户体系架构里的表空间管理）
上完1Z0-063第6章（多组户体系架构里的安全性维护）
上完1Z0-063第7章（备份恢复，尤其是PDB/TS的PITR中的AUXILIARY语法和原理，闪回容器数据库）
上完1Z0-063第8章（CDB资源计划和ADDM）
上完1Z0-063第9章（统一审计和导入和导出）
1Z0-052共19章（上完19章），1Z0-053共21章（上完21章），1Z0-063多租户部分共9章（上完9章）
总共上完全部49章中的49章

select username , default_tablespace, temporary_tablespace ,con_id
from cdb_users where username='LU' order by con_id;
select t.TABLESPACE_NAME, t.CONTENTS, t.CON_ID
from cdb_tablespaces t
order by t.con_id;
select d.name , t.name , t.con_id
from v$datafile d , v$tablespace t
where d.con_id=t.con_id
and d.ts#=t.ts#
and t.name like 'UNDO%';
----
select USERNAME, COMMON, CON_ID from cdb_users
order by 3;
--
select username , con_id from cdb_users
where common='NO'
order by con_id;
---
create user c##_USER identified by x container=all;
select USERNAME, COMMON, CON_ID from cdb_users
where username='C##_USER'
order by 3;
---
grant create session to c##_user container=all ;
---
select *
from cdb_sys_privs sp
where sp.GRANTEE='C##_USER';
---
create user local_user identified by x
container=current;
---
create user C##_USER2 identified by x;
select USERNAME, COMMON, CON_ID from cdb_users
where username='C##_USER2'
order by 3;
---
grant create session to c##_user2 ;
select *
from cdb_sys_privs sp
where sp.GRANTEE='C##_USER2';
drop user c##_user2;
----
select USERNAME, COMMON, CON_ID from cdb_users
where con_id=3
order by 1;
----
select *
from cdb_sys_privs sp
where sp.GRANTEE='LOCAL_USER_PDB2';
---
select role, COMMON, CON_ID from cdb_roles
order by 3,1;
create role c##_role ;
---
select role, COMMON, CON_ID from cdb_roles where common='NO';
select *
from cdb_role_privs rp
where rp.GRANTED_ROLE='C##_ROLE';
grant c##_role to c##_user;
grant c##_role to c##_user container=all;
select *
from cdb_role_privs rp
where rp.GRANTED_ROLE='C##_ROLE';
---
revoke c##_role from c##_user container=all;
revoke c##_role from c##_user container=current ;
---
select *
from cdb_role_privs rp
where rp.GRANTED_ROLE='LOCAL_ROLE_PDB2';
----
select *
from cdb_sys_privs sp
where sp.GRANTEE in ('C##_USER','LOCAL_USER_PDB2');
---
grant CREATE TABLE, UNLIMITED TABLESPACE to C##_USER
CONTAINER=ALL;
grant CREATE SEQUENCE to C##_USER CONTAINER=CURRENT;
select *
from cdb_sys_privs sp
where sp.GRANTEE in ('C##_USER','LOCAL_USER_PDB2')
and sp.PRIVILEGE='CREATE SEQUENCE';
select *
from cdb_sys_privs sp
where sp.GRANTEE in ('C##_USER','LOCAL_USER_PDB2')
and sp.PRIVILEGE='CREATE SYNONYM';
select * from cdb_CONTAINER_DATA
order by con_id,1;
CREATE USER c##jfv IDENTIFIED BY oracle_4U;
GRANT CREATE SESSION, SET CONTAINER TO c##jfv
CONTAINER=ALL;
GRANT SELECT ON sys.v_$session TO c##jfv CONTAINER=ALL;
SELECT username, con_id FROM v_$session
WHERE username IS NOT NULL AND username <> 'DBSNMP';
alter user c##jfv
set container_data=(cdb$root, pdb1_1, pdb2_2) for v_$session
container=current;
select * from cdb_CONTAINER_DATA
order by con_id,1;

复制代码