Applying Row-level Security to BI Tool Users
Row-level security provides the ability to restrict Noetix query user's access to data in global Noetix views. For the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types, row-level security is automatically configured based on their data access privileges in Oracle E-Business Suite. For Noetix query users of the Database User (Type U) type, row-level security is configured manually by the Noetix System Administration User in Noetix Views Administrator (NoetixViews Administrator). For more information on users and roles, seeAbout Noetix Query Users and Roles
After you define the row-level security for Noetix query users in NoetixViews Administrator, you can generate the Noetix query users and their row-level security settings into the meta-layers of Oracle Discoverer and Noetix WebQuery (NWQ) by using the Angles for Oracle Generator application for the respective business intelligence (BI) tools. When Noetix query users generated in these BI tools log on to these BI tools and query data from global views, global views validate the user information and data access privileges of the user to enforce row-level security.
However, BI tools such as Oracle Business Intelligence (Oracle BI), SAP BusinessObjects, and IBM Cognos Business Intelligence (Cognos BI) do not support row-level security settings defined for Noetix query users because the Noetix query users and their row-level security settings are not generated into the meta-layers of the BI tools. To support row-level security in these tools, you must register a BI tool user used in Oracle BI, BusinessObjects, or Cognos BI, and link the user to a Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type.
Linking a BI tool user to an existing Oracle E-Business Suite user who has been added as a Noetix query user in NoetixViews Administrator is a two step process. First, you have to create a BI tool for Oracle BI, BusinessObjects, or Cognos BI. After creating a BI tool, you must select a BI tool user available in the BI tool that you created and link that user to the Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type. For this user, you must also select an appropriate responsibility.
The BI Tool User Registration tab of the Security Manager dialog box in NoetixViews Administrator allows you to create a BI tool and link a Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type to a BI tool user used in the BI tools.
For information about how to add, modify, and remove BI tools, see Managing BI Tools.
For information about how to register BI tool users, modify the settings of registered BI tool users, and remove registered BI tool users, see Managing BI Tool Users.