A reader, July 19, 2024 - 7:29 am UTC
Thank you! you are the Houdini of oracle.
A reader, July 19, 2024 - 7:36 am UTC
plus can you please elaborate more on the "(and just grant then READ not SELECT privilege so they can't lock rows)"?
July 22, 2024 - 12:58 pm UTC
The SELECT privilege allows users to run SELECT ... FOR UPDATE statements which lock the affected rows. Worst case this allows denial of service attacks by running generic SELECT ... FOR UPDATE, locking out genuine changes.
The READ privilege only allows SELECT; the FOR UPDATE clause is disallowed.