Audit access to "credit_card" table by employee Bob
You must log into the database as Bob before proceeding with this page.
Operation
Execute the SQL statements in the right pane.
Solution
Bob is granted with SELECT, INSERT, and UPDATE privileges on 'credit_card' table through role 'custService'.
When he executes SQL statements, he will be able to retrieve data from 'credit_card' table.
SELECT, INSERT, UPDATE statement succeeds and DELETE statement fails. An entry will be made in audit log files.