How do we restrict the insert/ updates on the foreign column in a table if that table is in different instance that the table with Primary Key. Say for Example Emp and Dept Table. We have deptno in both tables and Deptno in Emp table is the Primary Key and other is foreign Key. How do we control what values we insert in Dept table if both the tables are not in the same instance.
RE: How do we restrict the insert/ updates on the fore...
see if you want totally restric insert and update create a view with required columns and give it to them. dont forget to readonly while creating the view.
