Read sensitivity of the data

By default, data in a table is only accessible to:

  • The userid that owns the table

  • Anyone with the SELECT ANY TABLE system privilege

Questions you’ll have to address include the following:

  • Will the application data be accessible to all users of the database?

  • Will different levels of access to the data be granted to different users?

  • Will object grants be given to each user, or will they be grouped using roles?

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.