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.