SQL windows block register unless a user is Read Only

[jjsanchez]

Hello all,
I have an issue with users granted READ ONLY on a Oracle Database.

If the user do SELECT from Table_Name FOR UPDATE in the SQL windows, the registers are blocked although the user has READ ONLY access to the database.

are they any option or parameter on the preferences to avoid that?.

Regards

 

[Marco Kalter]

If you are using Oracle12c then you can grant the user read privileges on the table instead of select privileges. I'm not sure if this can be prevented on Oracle11c or earlier.

 

[jjsanchez]

Thanks for the answer.

Unfortunately, we have Oracle 12.1.0.1 and this issue just works on Oracle 12.1.0.2.

Regards,