Overview of Applications DBA Duties
Applications database administration (DBA) combines the efforts of an Oracle Applications System Administrator and an ORACLE database administrator.
The database privileges of Oracle Applications products depend on their ORACLE usernames. ORACLE usernames are created by an ORACLE database administrator, and then are registered as ORACLE usernames by a System Administrator.
An ORACLE username identifies you as an authorized ORACLE database user.
- Each ORACLE username consists of a database username and password assigned by your database administrator.
- Each ORACLE username accesses a set of data within the ORACLE database.
Note that database usernames and passwords connect to the ORACLE database, while application usernames and passwords access Oracle Applications.
- Usually each Oracle application has its own ORACLE username, in which application-specific data resides. That is, the tables and other database objects owned by the application are accessed by the ORACLE username.
You access the ORACLE database through an Oracle Applications product, and the application's ORACLE username is what grants access privileges.
Registering an ORACLE username