Role based access by employee Bob


You must log into the database as Bob before proceeding with this page.

Bob is an employee of customer service department. Check if Bob can access 'credit_card' table data.


Operation


Bob acquires SELECT, INSERT, and UPDATE privileges through the 'custService' role.


Solution


The query results in the right pane show that user Bob is able to execute SELECT, INSERT, UPDATE statements successfully. But DELETE statement on the right pane will fail as Bob does not have DELETE privilege.