Types of Query Users

In Noetix Views (NoetixViews), Noetix query users’ access to data is determined by the roles, the Oracle General Ledger security access, and the custom Oracle Human Resources and Oracle U.S. Federal Financials security settings. When a user is set up to use Oracle Applications mode security, the Oracle
E-Business Suite responsibilities and security profiles assigned to the user can also provide limits on what data and views can be accessed.

Below is a description of Noetix query user types and definitions, as well as an explanation of when each Noetix query user type is best applied.

Database User (Type U)

Noetix query accounts of Database User (Type U) type can be accessed through any query tool or from SQL*Plus. 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 Type U user.

Oracle E-Business Suite Authenticated User and Responsibility (Types A and R)

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. These user types are valid only for Oracle E-Business Suite version 11.5.10.2 and later.

When a Type R user is added for an Oracle E-Business Suite responsibility, any user of Oracle E-Business Suite who has this responsibility can log on to an Oracle Applications mode EUL and access permitted business areas. Noetix query users of Type A and Type R are active only when you use Angles for Oracle Generator with an Applications mode EUL in Oracle Discoverer or if you use Noetix WebQuery (NWQ) as a reporting tool. These user types have no impact as database users and rely on their associated APPS database user account to maintain a link with the database. If you create a standard Discoverer EUL, then, only users of Noetix System Administration User (Type N) type, Oracle Administrative Database User (Type O) type, and Type U will be able to log on to Oracle Discoverer with the appropriate business areas.

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 Type R. 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, 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 users will not have to be individually added as Noetix query users of Type A; moreover, changes can be conveniently made to a few Noetix query users of Type R 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 Type R.

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

If the existing responsibilities do not provide a useful structure for reporting security, separate reporting responsibilities should be created in Oracle E-Business Suite as a means to grant access to Noetix views. These responsibilities are groups to put together users based on the access they can have to Noetix views and are not to be used by Oracle E-Business Suite.

This way only a group of users are allowed to access Noetix views instead of all the users of a particular responsibility. With this approach, license compliance becomes easier for the client.

When you use Noetix Platform, a user account in NQS is created for each Oracle E-Business Suite Authenticated User type user. When users log on to NWQ using those user accounts, they are prompted with a list of responsibilities and have to pick up the one they want to log on with. Noetix Platform can import these responsibilities only from Oracle E-Business Suite 11i and later.

Noetix System Administration User (Type N)

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.

Oracle Administrative Database User (Type O)

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 Type A and Type R 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 Type O and Type N users are database logon accounts that are automatically created as needed.

Noetix External Mapping User (Type M)

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.