DB_DEVELOPER_ROLE 롤

Oracle 23c에 개발자를 위한 DB_DEVELOPER_ROLE 롤이 추가되었습니다.

The DB_DEVELOPER_ROLE role provides an application developer with all the necessary privileges to design, implement, debug, and deploy applications on Oracle databases. By using this role, administrators no longer have to guess which privileges may be necessary for application development.

 

아래 쿼리로 DB_DEVELOPER_ROLE 롤에 부여된 시스템 권한, 오브젝트 권한, 롤을 확인할 수 있습니다.

-- 1-1
SELECT privilege, admin_option
  FROM dba_sys_privs
 WHERE grantee = 'DB_DEVELOPER_ROLE';
 
PRIVILEGE                  ADMIN_OPTION
-------------------------- ------------
CREATE ANALYTIC VIEW       NO
CREATE ATTRIBUTE DIMENSION NO
CREATE CUBE                NO
CREATE CUBE BUILD PROCESS  NO
CREATE CUBE DIMENSION      NO
CREATE DIMENSION           NO
CREATE DOMAIN              NO
CREATE HIERARCHY           NO
CREATE JOB                 NO
CREATE MATERIALIZED VIEW   NO
CREATE MINING MODEL        NO
CREATE MLE                 NO
CREATE PROCEDURE           NO
CREATE SEQUENCE            NO
CREATE SESSION             NO
CREATE SYNONYM             NO
CREATE TABLE               NO
CREATE TRIGGER             NO
CREATE TYPE                NO
CREATE VIEW                NO
DEBUG CONNECT SESSION      NO
EXECUTE DYNAMIC MLE        NO
FORCE TRANSACTION          NO
ON COMMIT REFRESH          NO
 
24 행이 선택되었습니다.
 
-- 1-2
SELECT owner, table_name, privilege, grantable, type
  FROM dba_tab_privs
 WHERE grantee = 'DB_DEVELOPER_ROLE';
 
OWNER TABLE_NAME               PRIVILEGE GRANTABLE TYPE
----- ------------------------ --------- --------- ------------
SYS   DBA_PENDING_TRANSACTIONS SELECT    NO        VIEW
SYS   JAVASCRIPT               EXECUTE   NO        MLE LANGUAGE
SYS   V_$PARAMETER             READ      NO        VIEW
SYS   V_$STATNAME              READ      NO        VIEW
 
4 행이 선택되었습니다.
 
-- 1-3
SELECT granted_role, admin_option, delegate_option, default_role
  FROM dba_role_privs
 WHERE grantee = 'DB_DEVELOPER_ROLE'; 
 
GRANTED_ROLE ADMIN_OPTION DELEGATE_OPTION DEFAULT_ROLE
------------ ------------ --------------- ------------
CTXAPP       NO           NO              YES
SODA_APP     NO           NO              YES
 
2 행이 선택되었습니다.