SQL Developer

Dear Community Members,

I'm trying to explore the unit testing for my project using sql developer, but while trying to create the repository I'm stuck on the assign grants pop-up, the same comes back in loop again and again see the screenshots.

To begin with:

I have installed a DB on my local machine

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Using Version 19.4.0.354 Build 354.1759 of SQL Developer.

Have created a user named "ATOMIC" and trying to create the repository on the same for unit testing.

Executed below manually:

alter session set "_ORACLE_SCRIPT"=true;

create role UT_REPO_ADMINISTRATOR;

create role UT_REPO_USER;

grant create public synonym,drop public synonym to UT_REPO_ADMINISTRATOR;

grant select on dba_role_privs to UT_REPO_USER;

grant select on dba_role_privs to UT_REPO_ADMINISTRATOR;

grant select on dba_roles to UT_REPO_ADMINISTRATOR;

grant select on dba_roles to UT_REPO_USER;

grant select on dba_tab_privs to UT_REPO_ADMINISTRATOR;

grant select on dba_tab_privs to UT_REPO_USER;

grant execute on dbms_lock to UT_REPO_ADMINISTRATOR;

grant execute on dbms_lock to UT_REPO_USER;

grant UT_REPO_USER to UT_REPO_ADMINISTRATOR with admin option;

grant UT_REPO_ADMINISTRATOR to "ATOMIC" with admin option;

--ATOMIC:

Grant CREATE MATERIALIZED VIEW to ATOMIC;

Grant CREATE TABLE to ATOMIC;

Grant UNLIMITED TABLESPACE to ATOMIC;

Grant CREATE VIEW to ATOMIC;

Grant CREATE TYPE to ATOMIC;

Grant CREATE SYNONYM to ATOMIC;

Grant DEBUG CONNECT SESSION to ATOMIC;

Grant CREATE ANY DIRECTORY to ATOMIC;

Grant CREATE TRIGGER to ATOMIC;

Grant CREATE SESSION to ATOMIC;

Grant DEBUG ANY PROCEDURE to ATOMIC;

Grant CREATE PROCEDURE to ATOMIC;

Grant CREATE PUBLIC DATABASE LINK to ATOMIC;

Grant CREATE DATABASE LINK to ATOMIC;

Grant CREATE SEQUENCE to ATOMIC;

Grant connect, resource, create view to "ATOMIC";

See screenshots for issue details:

This is going in this loop.