Access table data by manager Joe from trusted connection


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


Joe is the manager of customer service department. Check if he can access 'credit_card' table data.



Operation


Joe gets 'Mgr' role privileges to perform SELECT, INSERT and UPDATE operations on 'credit_card' table. However DELETE operation by Joe is not allowed.



Solution


The query results in the right pane show that user Joe is able to successfully execute the SQL statements a 'Mgr' role is allowed when connected through trusted connection.