Access to table by employee Bob


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

Bob is an employee of customer service department of SOUTH region. He is granted with security label 'SOUTH' with ALL ACCESS.

Check which records of 'dailysales' table will Bob be able to access.


Operation


Execute the SELECT statement on the right pane.

SECLABEL_TO_CHAR function returns a string representation of values that make up a security label. This is useful when we want to display user-friendly output of the DB2SECURITYLABEL columns.

Solution


Since Bob is granted with security label 'SOUTH', he will be able to access all records associated with security label is 'SOUTH'. Thus Bob can only see south region sales information.