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.