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.
|