Steps to create/drop a private DB link - without user credentilas/ using proxy user

Steps to create/drop a private DB link - without user credentilas

Here, some how the DB link is not working, I have to recreate it to fix the issue, but I don't know user credentials.

I performed below steps

Granted the proxy user priveleges to another user.

alter user TEAM1 grant connect through PD1;

Grant succeeded.

SQL> conn PD1[TEAM1]
Enter password: PD1Password
Connected.
SQL> show user;
USER is "TEAM1"
SQL>  select name from v$database;

NAME
---------
M01

Drop database link DLNK;

CREATE DATABASE LINK DLNK CONNECT TO REPORT1 IDENTIFIED BY Password USING 'PR01';

SQL>  select name from v$database@DLNK;

NAME
---------
PR01

Revoked the privelege when DB link verified

alter user TEAM1 revoke  connect through PD1;

Reference - Using JDBC to Connect Through a Proxy User (Doc ID 227538.1)