Awhile back, I was tasked with creating a database link in another user’s schema, when I wasn’t able to login as the user.¬† I searched the internet–the majority of articles said that it couldn’t be done, and they encouraged people to create public database links instead of private database links.

Well, I found a working method–here it is.¬† Just replace INSERT_USERNAME¬† with your intended target schema.