types of Database Users in Oracle or data base

Database Users:- The  database users is depend on the database site. The database users, roles and responsibilities depend on the database site. A small site can have one database administrator who administers the database for application developers and users. A very large site can find it necessary to divide the duties of a database administrator among several people and among several areas of specialization.

The types of Database Users in Oracle:-

1. Database Administrators
2. Security Administrators
3. Network Administrators
4. System Administrators
5. Application Developers
6. Testing
7. Power User
8. End User

1. Database Administrator (DBA):- The Database Administrators is a person or a group of persons who is responsible for the management of the database. The Database Administrators is responsible for authorizing access to the database by grant and revoke permissions to the users. The Database Administrators managing backups and repairing damage due to hardware and software failures. In case of small organization the role of Database Administrators is performed by a single person and in case of large organizations there is a group of Database Administrators who share responsibilities.

Task Of Database Administrators:

• Installing and upgrading the Oracle server and application tools.
• Allocating system storage and planning future storage requirements for the database system.
• Creating primary database storage structures (tablespaces) after application developers have designed an application.
• Creating primary objects (tables, views, indexes) once application developers have designed an application.
• Modifying the database structure, as necessary, from information given by application developers.
• Enrolling users and maintaining system security.
• Ensuring compliance with your Oracle license agreement.
• Controlling and monitoring user access to the database.
• Monitoring and optimizing the performance of the database.
• Planning for backup and recovery of database information.
• Maintaining archived data on tape.
• Backing up and restoring the database.
• Contacting Oracle Corporation for technical support.

2. Security Administrators:- In some cases, a site assigns one or more security officers to a database. A security officer enrolls users, controls and monitors user access to the database, and maintains system security. As a DBA, you might not be responsible for these duties if your site has a separate security officer.

3. Network Administrators:- Some sites have one or more network administrators. Network administrators may be responsible for administering Oracle networking products.

4. System Administrators:- When a database is created, the user System, identified by the password manager, is also automatically created and granted all system privileges for the database. The System username creates additional tables and views that display administrative information, and internal tables and views used by Oracle tools. Never create in the System schema tables of interest to individual users.

5. Applications Developers:-An application developer designs the application and implements database application. An applications developers specifying modifications of the database structure for an application. Application developer are responsible for writing application programs that use the database. These application programs operate on the data to perform various operations such as retaining information, creating new information, deleting or changing existing information.

Tasks Of Application Developers:

• Designing and developing the database application.
• Designing the database structure for an application.
• Estimating storage requirements for an application.
• Specifying modifications of the database structure for an application.
• Relaying the above information to a database administrator.
• Tuning the application during development.
• Establishing an application's security measures during development.

6. End Users:-End Users are the people who interact with the database through applications or utilities.

The various categories of end users are:-
1. Casual End Users - These Users occasionally access the database but may need different information each time. They use sophisticated database Query language to specify their requests. For example: High level Managers who access the data weekly or biweekly.

2. Native End Users - These users frequently query and update the database using standard types of Queries. The operations that can be performed by this class of users are very limited and effect precise portion of the database.

3. Standalone end Users/On-line End Users - Those end Users who interact with the database directly via on-line terminal or indirectly through Menu or graphics based Interfaces.

7. Power User:- A power user is a user of a personal computer who has the ability to use advanced features of programs which are beyond the abilities of "normal" users, but is not necessarily capable of programming and system administration.