Object Security

To view data, users must have privileges on a particular Business Area instance.

You can use a view to display for selection only the Business Area instances to which the current user has access; see Display User's Business Area Instances.

During installation the system creates synonyms in the Business Area instance schema for all the Table Descriptors. The synonyms reference source views in the Work Area schema(s) containing the actual database tables corresponding to the Table instances mapped to the Table Descriptors. The source views enforce normal Oracle LSH security.

Note:

It is not necessary to have privileges on the Table instances mapped to the Business Area instance's Table Descriptors unless the user needs to be able to view currently blinded data.