oracle23c新特性学习-m6米乐安卓版下载

目录

2023年4月3日，oracle cloudworld tour –甲骨文宣布推出免费开发者版 oracle database 23c
安装了oracle vm virtualbox虚拟机
下载了oracle_database_23c_free_developer_appliance.ova
文件大小6.51g
把ova导入到vm中

文件

安装好登录进去的画面

登录oracle 23c数据库

查看里面的pdb

1、角色的作用

使用人员：应用程序开发人员。
权限：系统权限、对象权限、预定义角色、pl/sql包权限和tracing权限。
范围：既可以用于cdb根目录，也可以用于pdb
更改：不能修改db_developer_role角色，只能在oracle数据库升级或降级时修改。

2、查询各个权限

1、查询role_tab_privs

sql> select * from role_tab_privs where role=‘db_developer_role’;

role		     owner		  table_name			 column_name	      privilege 			       gra com inh
-------------------- -------------------- ------------------------------ -------------------- ---------------------------------------- --- --- ---
db_developer_role    sys		  javascript					      execute				       no  no  no
db_developer_role    sys		  v_$statname					      read				       no  yes yes
db_developer_role    sys		  v_$parameter					      read				       no  yes yes
db_developer_role    sys		  dba_pending_transactions			      select				       no  yes yes

2、查询role_sys_privs

sql> select * from role_sys_privs where role=‘db_developer_role’;

role		     privilege				      adm com inh
-------------------- ---------------------------------------- --- --- ---
db_developer_role    create domain			      no  yes yes
db_developer_role    create mle 			      no  yes yes
db_developer_role    create analytic view		      no  yes yes
db_developer_role    create hierarchy			      no  yes yes
db_developer_role    create attribute dimension 	      no  yes yes
db_developer_role    execute dynamic mle		      no  yes yes
db_developer_role    create cube build process		      no  yes yes
db_developer_role    create cube			      no  yes yes
db_developer_role    create cube dimension		      no  yes yes
db_developer_role    create mining model		      no  yes yes
db_developer_role    create job 			      no  yes yes
db_developer_role    debug connect session		      no  yes yes
db_developer_role    on commit refresh			      no  yes yes
db_developer_role    create dimension			      no  yes yes
db_developer_role    create type			      no  yes yes
db_developer_role    create materialized view		      no  yes yes
db_developer_role    create trigger			      no  yes yes
db_developer_role    create procedure			      no  yes yes
db_developer_role    force transaction			      no  yes yes
db_developer_role    create sequence			      no  yes yes
db_developer_role    create view			      no  yes yes
db_developer_role    create synonym			      no  yes yes
db_developer_role    create table			      no  yes yes
db_developer_role    create session			      no  yes yes
24 rows selected.

3、查询role_role_privs

sql> select * from role_role_privs where role=‘db_developer_role’;

role		     granted_role	  adm com inh
-------------------- -------------------- --- --- ---
db_developer_role    soda_app		  no  yes yes
db_developer_role    ctxapp		  no  yes yes