Description of the illustration data_sec_3.gif

The image shows that the Administrator user can see both the Inventory Total and the Booked Amount column, and can generate queries on both columns and see return results. The user Anne Green, however, only sees the Inventory Total column. Even if the SQL query in the Issue SQL field in Oracle BI EE has been modified to include the Booked Amount column, the user-based permissions ensure that an error is returned rather than results for the forbidden column.