Oracle Database 23ai: New feature - DB_DEVELOPER_ROLE -

June 1, 2023 | 3 minute read
Text Size 100%:

Oracle Database 23ai: New feature - DB_DEVELOPER_ROLE -

 

Logo, icon

Description automatically generated

 

Starting with Oracle Database 23ai, the new role "DB_DEVELOPER_ROLE" allows administrators quickly assign all necessary privileges developers need to design, build, and deploy applications for the Oracle Database. (Include System privileges required to build a data model and Object privileges required to monitor and debug applications).

By using this role, administrators no longer have to guess which privileges may be necessary for application development.

Oracle recommends that you grant the application developer the DB_DEVELOPER_ROLE role, rather than individually granting these privileges or granting the user the DBA role, as the DB_DEVELOPER_ROLE role adheres to least-privilege principles and ensures greater security for the development environment.

The DB_DEVELOPER_ROLE role can be use in either the CDB root or the PDB.

The following SQL statements allows you to retrieve the privileges assigned to this role:

For Sys Privileges

SQL> SELECT privilege FROM role_sys_privs WHERE role='DB_DEVELOPER_ROLE' ORDER BY 1;

 

For Object Privileges

SQL> SELECT table_name, privilege FROM role_tab_privs WHERE role = 'DB_DEVELOPER_ROLE' ORDER BY 1;

 

For: Other functionalities - Roles

Enable SODA_APP role to work with JSON collections - (Simple Oracle Document Access (SODA)).

The CTXAPP role is a system-defined role that enables users to create and delete Oracle Text preferences. The CTXAPP role allows users create preferences and use the PL/SQL packages.

SQL> SELECT granted_role FROM role_role_privs WHERE role ='DB_DEVELOPER_ROLE';

If you want to add or revoke the role, you can use the next sentences:

SQL> GRANT DB_DEVELOPER_ROLE TO <user_name>;

SQL> REVOKE DB_DEVELOPER_ROLE FROM <user_name>;

 

Read more details about this or other new feature.

https://docs.oracle.com/en/database/oracle/oracle-database/23/nfcoa/introduction.html

https://www.oracle.com/database/23c/

 

Hope you like this new feature and check our upcoming articles regarding other new features.

 

 

Pedro T.


Previous Post

Develop MongoDB Applications with Oracle Autonomous Database on Dedicated Exadata Infrastructure

Next Post


Oracle Enterprise Manager Technology Forum 2023

David Le Roy | 2 min read