We are trying to insert into remote table using dblink and it gives us following error
ORA-01031: insufficient privileges
ORA-02063: preceding line from DEV3
The owner of the table and db_link authentication is same.
It works when we try to insert using same owner. But when I try to insert using different user I am getting error.
below is the insert statement inside a procedure.
Insert into DRM.USER_REPLICATION@DEV3
(USERNAME, NEW_PASSWORD, DT_CREATED, SOURCE_HOSTNAME, DEST_HOSTNAME, ACTION, PROCESSED)
('PM', 'A37241F579C2D44D', TO_DATE('11/13/2008 10:53:26', 'MM/DD/YYYY HH24:MI:SS'), 'xin', 'dev3', 'Password Change', 'Y');
All user will change password and user procedure to insert data into the table. I dont understand why I am getting this error and what privileges I need to give to all user to insert data from remote database