Access 'credit_card' table by manager Joe


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


Joe is the manager of customer service department. He is granted 'TOP_SECRET' security label through role 'Mgr'. Check what columns of 'credit_card' table can Joe access.

Operation


Execute SELECT statement given on the right pane.

Solution


Joe has privileges to perform SELECT operation as shown. Since Joe is granted with TOP_SECRET security label, he is able to access all columns of 'credit_card' table .