How to block readers in Oracle?
BugsApr 23 2007 — edited Oct 7 2007Hi,
We would like to implement the below requirement in Oracle as IDMS behaves so in mainframe world .
Lock a specific record so that other users should not be able to select,insert,update,delete that row.
How do we implement this?
We tried select..for update that works perfectly for DML and not for select.
But we need to restrict SELECT too.
Can somebody throw light on this?
Thanks