Access 'credit_card' table by employee Bob


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


Bob is an employee of J.K.Avro superstore. He is granted 'SECRET' security label through role 'custService'. Check what columns of 'credit_card' table can Bob access.

Operation


Execute SELECT statement given in the right pane.

Solution


Bob does not have privileges to perform SELECT operation as he is granted 'SECRET' security label with only WRITE ACCESS. Hence he will not be able to read any columns from the 'credit_card' table.