Hi all,
Db version 11.2.0.1
Os Red hat 5.5
I have created a private database link by following way
create database link test_link
connect to Scott identified by tiger
using
'(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.194.180.45)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = prod)
)
)'
The link is created successfully and i am able to perform all DML operations on it.
The Question is there any way by which we can grant only insert or delete or privilege not to delete from the table to this link.
For only select operations i know that by creating a view i can restrict the remote connecting user but is there any way by which i can give only insert or to revoke delete through database link.