Registering an ORACLE username
The installation process automatically registers Oracle Applications ORACLE usernames, so you only need to register any additional ORACLE usernames that you need using the ORACLE Users window.
You must register an ORACLE username with Oracle Applications if:
- you create a custom application using Oracle Application Object Library
- you want to associate an additional ORACLE username with an Oracle Applications product
Attention: Before you can register an ORACLE username, your database administrator must first create an ORACLE username that connects to the ORACLE database. You then use the ORACLE Users window to register your ORACLE username.
Registering a new ORACLE username using the ORACLE Users window submits a concurrent request that sets up the necessary privileges to the Oracle Application Object Library database tables you need to run your application. These database tables contain information to allow your users access to Oracle Application Object Library features, such as menus and flexfields.
Reregistering ORACLE usernames
You should also reregister ORACLE usernames associated with custom applications built using Oracle Application Object Library each time you upgrade Oracle Application Object Library
When you change the privileges that an already registered ORACLE username has to the Oracle Application Object Library database tables:
- Oracle Applications then submits a concurrent request to create or recreate privileges to the Oracle Application Object Library database tables.
- The concurrent request must complete successfully in order for your changes to take effect.
Registering an ORACLE username as "Restricted"
Oracle Applications let you register ORACLE usernames as Restricted ORACLE usernames. A restricted ORACLE username prevents users from modifying data in Oracle Application Object Library tables.
Your database administrator can set up the ORACLE username to prevent users from modifying data in other Oracle Applications tables.
You can register an ORACLE username as restricted using the ORACLE Users window.
- When you register an ORACLE username as restricted, you submit a concurrent request that sets up read-only privileges to the Oracle Application Object Library database tables.
- Users with responsibilities that access restricted ORACLE usernames have read-only privileges to the Oracle Application Object Library database tables, which prevents them from inserting, updating, or deleting data related to such Oracle Application Object Library features as menus, flexfields, and so on.
Defining Data Groups
A data group assigns an ORACLE username to an Oracle Applications product, and includes a list of the valid Application-ORACLE username pairs.
The installation process automatically defines Data Groups for Oracle Applications, so you only need to define any additional data groups that you wish to utilize. See: Defining Data Groups. See: Data Groups.
See Also
Overview of Applications DBA Duties
ORACLE Users