Skip to main content

About Noetix Query Users and Roles

Noetix query users are database or Oracle E-Business Suite users who are granted access to a set of Noetix views. Noetix query users can be set up from database users or Oracle E-Business Suite users or responsibilities after completing the generation process.

The NOETIX SYS user creates Noetix query users by selecting database users or creating them (requires DBA privileges) and granting these users sets of Noetix roles appropriate for the users' security level and information-access needs. Thereafter, the database users are considered as Noetix query users. Oracle E-Business Suite users and responsibilities can also be set up as Noetix query users to take advantage of Oracle E-Business Suite applications row-level security. In this case, they are set up as Noetix query users with access to the appropriate roles.

Noetix query users are granted access privileges to Noetix views by being granted a set of Noetix roles. The Noetix roles are created as part of the generation process and each role provides access to a set of views. By selecting a role, you grant the users access to data in a subset of views.

In NoetixViews, you can assign roles to Noetix query users, and set up access to data in Noetix views for various Oracle E-Business Suite modules using the Noetix Query User Maintenance tab of the Security Manager dialog box. The Oracle E-Business Suite responsibilities and security profiles of a user can be inherited in NoetixViews to determine the user's access to data in Noetix views.

Noetix Query User Types

There are five types of Noetix query users that can be set up or are set up during generation.

Type code

Name

Description

Type U

Database User

Noetix query accounts of Database User (Type U) type can be accessed through any query tool or from SQL*Plus. Noetix Views (NoetixViews) allows only users of this type to create synonyms and optimize views. Typically, the query users you create will be of this type. These user accounts should correspond to existing users in the database, and there should be no differences in capability. When you use Noetix Platform, a user account is created in Noetix QueryServer (NQS) for each Database User (Type U) type user.

Type N

Noetix System Administration User

The Noetix System Administration User (Type N) is a special query user account associated with the current NOETIX SYS schema. This account is created during generation. Optimizing views and synonyms cannot be created for the NOETIX SYS user.

Type O

Oracle Administrative Database User

The Oracle Administrative Database User (Type O) is defined automatically depending on the APPS user in Oracle E-Business Suite. It is possible to have multiple Oracle Administrative Database Users if there are multiple APPS users in Oracle E-Business Suite.

The Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types rely on the APPS user to maintain a link with the database. Therefore, the APPS user should have the responsibilities and privileges in Oracle E-Business Suite that are required for the Noetix query users to effectively query the database through Noetix views.

The Oracle Administrative Database User (Type O) and Noetix System Administration User (Type N) are database logon accounts that are automatically created as needed.

Type M

Noetix External Mapping User

The Noetix External Mapping User (Type M) is a business intelligence (BI) tool user who is mapped to a Type A Noetix query user and inherits the security settings of the Type A user to enforce advanced security for the BI tool user in the BI tool.

Type A and R

Oracle E-Business Suite Authenticated User and Responsibility

Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Suite Authenticated Responsibility (Type R) types are defined in Oracle E-Business Suite. These are not Oracle database accounts and are used to support Applications mode capability within Oracle Discoverer.

These users are automatically added to an Applications mode End User Layer (EUL) when used in conjunction with Angles for Oracle Generator for Oracle Discoverer (Angles for Oracle Generator). If you do not plan on using Oracle Discoverer’s Applications mode authentication, then you should not establish users of these types.

For convenience, set up responsibilities in Oracle E-Business Suite, and assign these responsibilities to Oracle E-Business Suite users. Then, add these responsibilities as Noetix query users of the Oracle E-Business Suite Authenticated Responsibility (Type R) type. Assign Noetix roles to these Noetix query users, and set up access to data in views for various Oracle E-Business Suite modules using the Noetix Query User Maintenance tab of the Security Manager dialog box. After these Noetix query users are generated into the Noetix Metadata Repository (NMR) with the use of the Angles for Oracle Generator for Noetix Platform—Oracle E-Business Suite Edition (Angles for Oracle Generator) or extracted into the Applications mode EUL with the use of the Angles for Oracle Generator, Oracle E-Business Suite users can log on to NWQ or the EUL with their Oracle E-Business Suite credentials and thereafter pick the responsibilities that have been assigned to them in Oracle E-Business Suite and also set up as Noetix query users. Thus, the Oracle E-Business Suite users will not have to be individually added as Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) type; moreover, changes can be conveniently made to a few Noetix query users of the Oracle E-Business Suite Authenticated Responsibility (Type R) type instead of numerous Type A users. You cannot log on to NWQ or to a third-party reporting tool as a Noetix query user of the Oracle E-Business Suite Authenticated Responsibility (Type R) type.

For an Oracle E-Business Suite user, you can set up a Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type and as well as set up a Noetix query user of the Oracle E-Business Suite Authenticated Responsibility (Type R) type for its responsibility. When both of them have been set up in NoetixViews Administrator, the access mode assigned to the Noetix query user of the Oracle E-Business Suite Authenticated User (Type A) type will take precedence.

For more information about Noetix query users, see the chapter "Noetix Query User Management" in the MagnitudeNoetixViews Administrator Guide.

The following topics explain the concepts and procedures related to the Noetix Query users and roles:

Was this article helpful?

We're sorry to hear that.