Write sensitivity of the data
By default, tables can only be modified by:
The owner of the table
Anyone with INSERT ANY TABLE, UPDATE ANY TABLE, or DELETE ANY TABLE system privileges for inserts, updates, or deletes
In addition to the questions listed above for select access, questions you’ll have to address include the following:
Will some tables contain data that can be updated?
Should some tables be used as logs, with insert-only access granted to users?
Will some data need to be reconstructed so that rows can’t ever be deleted, only marked as being logically deleted?
Will some data need to be reconstructed so that rows can’t ever be deleted, only marked as being replaced with new rows inserted?
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
