Access to table by manager Sue


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

Sue is a general manager of coastal east and west regions. She is granted security label 'COASTAL'.

Check which regions of data can Sue access from the 'dailysales' table.

Operation


Execute SELECT statement on the right pane.

Solution


Since Sue is granted with security label 'CENTRAL', she is able to access all record of 'dailysales' table which are associated with security labels EAST and WEST.