oracle数据库 ppas 报价_从自建Oracle迁移至RDS PPAS

#本示例以名称为dtstest的数据库账号为例介绍授权命令，需要对PDB和CDB同时授权

#PDB授权示例：

create user dtstest IDENTIFIED BY rdsdt_dtsacct;

grant create session to dtstest;

grant connect to dtstest;

grant resource to dtstest;

grant select on all_objects to dtstest;

grant select on all_tab_cols to dtstest;

grant select on dba_registry to dtstest;

grant select any table to dtstest;

grant select any transaction to dtstest;

-- v$log privileges

grant select on v_$log to dtstest;

-- v$logfile privileges

grant select on v_$logfile to dtstest;

-- v$archived_log privileges

grant select on v_$archived_log to dtstest;

-- v$parameter privileges

grant select on v_$parameter to dtstest;

-- v$database privileges

grant select on v_$database to dtstest;

-- v$active_instances privileges

grant select on v_$active_instances to dtstest;

-- v$instance privileges

grant select on v_$instance to dtstest;

-- V$PDBS privileges

grant select on V_$PDBS to dtstest;

grant select on sys.USER$ to dtstest;

grant select on SYS.OBJ$ to dtstest;

grant select on SYS.COL$ to dtstest;

grant select on SYS.IND$ to dtstest;

grant select on SYS.ICOL$ to dtstest;

grant select on SYS.CDEF$ to dtstest;

grant select on SYS.CCOL$ to dtstest;

grant select on SYS.TABPART$ to dtstest;

grant select on SYS.TABSUBPART$ to dtstest;

grant select on SYS.TABCOMPART$ to dtstest;

#CDB授权示例：

create user dtstest IDENTIFIED BY rdsdt_dtsacct;

grant create session to dtstest;

grant LOGMINING TO dtstest;

-- v$logmnr_contents privileges

grant select on v_$logmnr_contents to dtstest;