Skip to main content

Refresh Security for Query Users

Refresh Security for Query Users

The data access privileges of Noetix query users are determined by a security data cache. The settings in the security data cache determine the organizational units for the views modules that query users can access. In the case of Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types, the security data cache stores information about the access of the corresponding Oracle E-Business Suite users and responsibilities to organizational units in Oracle E-Business Suite. However, the default settings can be overridden by the privileges specified in the Noetix Query User Maintenance tab of the Security Manager dialog box.

The security data cache is initially loaded during Stage 4 and thereafter refreshed during the regeneration if changes in the versions of NoetixViews Administrator, NoetixViews scripts, and Oracle E-Business Suite organizational units and security configurations are detected. The security data cache can also be refreshed when required through the use of the Refresh Security icon () on the toolbar of the NoetixViews Administrator or at scheduled intervals through a Concurrent Manager job. The Concurrent Manager job is automatically created and configured along with the default schedule during the generation. To change this schedule, log on to Oracle E-Business Suite as the XXNAO user, who is automatically created by NoetixViews and has access to all the NOETIX SYS schemas. You can then see or modify requests for any NOETIX SYS schema.

The following list provides information about the support for security data cache in NoetixViews:

  • For all the global form of the Noetix views except for the global views for Oracle Advanced Supply Chain Planning, Oracle Grants, Oracle Process Manufacturing, and Oracle Project Manufacturing, the security data cache maintains data access privilege changes and provides the functionality to reflect organizational unit and application specific security changes.

    For more information on data access privilege, organizational unit, and application specific security settings, see Data Security in NoetixViews.

  • For the standard and Cross Operations Extension (XOP) forms of views for Oracle U.S. Federal Financials, the security data cache maintains security changes similar to row-level security and provides the functionality to reflect organizational unit and application-specific security changes.

  • For Oracle General Ledger, in standard and XOP views that support the Accounting Flexfield, the security data cache stores settings for security that is similar to row-level security and provides the functionality to reflect changes in these settings.

  • For the standard form of the views for Oracle Advanced Benefits, Oracle Human Resources, Oracle Payroll, and Oracle Time and Labor, the security data cache maintains settings for security that is similar to row-level security and provides the functionality to reflect changes in these settings.

Was this article helpful?

We're sorry to hear that.