Role based access by manager Joe


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


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

Operation


Through role 'Mgr', Joe has privileges to perform SELECT, INSERT, UPDATE, and DELETE operations on 'credit_card' table.



Solution


The query results in the right pane show that user Joe is able to successfully execute all the SQL statements.