Oracle Error ORA-16279: supplied dblink does not have sufficient privileges

Oracle Error Message

ORA-16279: supplied dblink does not have sufficient privileges

Reason for the Error

A dblink was specified that lacked one or more of the CONNECT, RESOURCE, or SELECT_CATALOG_ROLE roles or that connects to a user with insufficient privileges to lock the table.

Solution

Grant the necessary privileges to the dblink and the user to which the dblink connects and retry the operation.