Access to table data by Bob


You must log into the database as Bob through trusted context 'trCtx' before proceeding with this page.

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

Operation


Bob acquires SELECT privilege through the 'custService' role.

Solution


The query results in the right pane show that user Bob is able to execute SELECT statement successfully. ALL other statements on the right pane will fail as Bob does not have privileges.