Access to table data by Manager Joe from non-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 when connected from non-trusted connection.
Operation
Joe gets default role 'Mgr' privileges to perform SELECT, INSERT and UPDATE operations on 'credit_card'
table.
Solution
The query results in the right pane show that user Joe is not able to execute any of the SQL statements when
connected through non-trusted connection. Joe gets the privileges only when connection through trusted connection.