Managing Database Account Privileges for Generic Visualization Business Areas

You can grant (and revoke) Read Data and Read Unblind privileges to database accounts for specific Business Area instances.

Your company can use the Generic Visualization adapter to integrate an external data visualization tool with Oracle LSH. After integration, Definers must create Generic Visualization Business Area instances to allow access to specified sets of data through the visualization tool.

Unlike other Business Areas, which are installed in their Work Area's schema, each Generic Visualization Business Area instance is installed in its own schema outside the Work Area schema. There are simplified security requirements for data in this schema.

The database account can have one or two privileges assigned:

  • Read Data: This privilege allows the user to view data that was never blinded and dummy data in Table instances that are currently blinded. All database accounts that should have access to the Business Area instance data should have this privilege.
  • Read Unblind: This privilege allows the user to view data that has been permanently unblinded.

If a user should be able to view currently blinded data, they must have a user account with all the required Blind Break privileges and a linked database account.

  1. Select Security from the Navigation menu in the upper right corner of Oracle DMW.
    The page refreshes to display the Security interface. The Roles tab is selected by default.
  2. Click the BA DB Privilege Access tab, located on the top right of the screen.
  3. Start typing at least three characters to see a list of Domains. Click the Domain to select.
  4. Select an Application from the Select Application Area drop down.
  5. Select a Work Area from the Select Work Area drop down menu.
  6. Select a Business Area from the Select Business Area Instance drop down menu.
    The area below the selection drop down menus refreshes to display a table with two rows: Read Access and Read Unblind Access.
  7. Click + in the Manage column to Add or Remove Users from either Read Access or Read Unblind Access.
  8. Click Save.