Access table data by manager Sue from trusted connection


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


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



Operation


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



Solution


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