While not typically necessary in newer versions of Oracle, some older installations may require that you manually specify the access rights the new user has to a specific schema and database tables.
For example, if we want our
books_admin user to have the ability to perform
DELETE capabilities on the
books table, we might execute the following
This ensures that
books_admin can perform the four basic statements for the
books table that is part of the