Pensando em facilitar a vida dos desenvolvedores, a Oracle criou a role DB_DEVELOPER_ROLE, esta role facilita e agiliza a vida do DBA e desenvolvedor. Antes da existência desta role, seria necessário aplicar as permissões de forma granular por tipo de objeto, abaixo grant e permissões incluidas na role DB_DEVELOPER_ROLE.
Iremos criar o usuário CESAR_DEV no PDB FREEPDB1 e verificar os privilégios ao aplicar a role DB_DEVELOPER_ROLE para o usuário CESAR_DEV:
SQL> ALTER SESSION SET CONTAINER=FREEPDB1;
Session altered.
SQL> show con_name
CON_NAME
------------------------------
FREEPDB1
SQL>
SQL> CREATE USER CESAR_DEV IDENTIFIED BY CESAR;
User created.
SQL> grant create session to CESAR_DBA;
Grant succeeded.
SQL> GRANT DB_DEVELOPER_ROLE TO CESAR_DEV;
Grant succeeded.Verificando privilégios do usuário CESAR_DEV ao ser incluido na role DB_DEVELOPER_ROLE:
[oracle@srv23dev ~]$ sqlplus CESAR_DEV/CESAR@localhost:1521/FREEPDB1
SQL*Plus: Release 23.0.0.0.0 - Developer-Release on Wed Apr 5 07:16:31 2023
Version 23.2.0.0.0
Copyright (c) 1982, 2023, Oracle. All rights reserved.
Last Successful login time: Tue Apr 04 2023 21:18:28 -03:00
Connected to:
Oracle Database 23c Free, Release 23.0.0.0.0 - Developer-Release
Version 23.2.0.0.0
SQL> select * from session_privs order by privilege;
PRIVILEGE
----------------------------------------
CREATE ANALYTIC VIEW
CREATE ATTRIBUTE DIMENSION
CREATE CUBE
CREATE CUBE BUILD PROCESS
CREATE CUBE DIMENSION
CREATE DIMENSION
CREATE DOMAIN
CREATE HIERARCHY
CREATE JOB
CREATE MATERIALIZED VIEW
CREATE MINING MODEL
CREATE MLE
CREATE PROCEDURE
CREATE SEQUENCE
CREATE SESSION
CREATE SYNONYM
CREATE TABLE
CREATE TRIGGER
CREATE TYPE
CREATE VIEW
DEBUG CONNECT SESSION
EXECUTE DYNAMIC MLE
FORCE TRANSACTION
ON COMMIT REFRESH
24 rows selected.
SQL>