Oracle7 Server Administrator's Guide
Types of Oracle7 Users
At your site, the types of users and their responsibilities may vary. For example, at a large site the duties of a database administrator might be divided among several people.
This section includes the following topics:
Database Administrators
Because an Oracle7 database system can be quite large and have many users, someone or some group of people must manage this system. The database administrator (DBA) is this manager. Every database requires at least one person to perform administrative duties.
A database administrator's responsibilities can include the following tasks:
- installing and upgrading the Oracle7 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 Oracle7 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
Security Officers
In some cases, a database might also have one or more security officers. A security officer is primarily concerned with enrolling users, controlling and monitoring user access to the database, and maintaining system security. You might not be responsible for these duties if your site has a separate security officer.
Application Developers
An application developer designs and implements database applications An application developer's responsibilities include the following tasks:
- 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
Application Administrators
An Oracle site might also have one or more application administrators. An application administrator is responsible for the administration needs of a particular application.
Database Users
Database users interact with the database via applications or utilities. A typical user's responsibilities include the following tasks:
- entering, modifying, and deleting data, where permitted
- generating reports of data
Network Administrators
At some sites there may be one or more network administrators. Network administrators may be responsible for administering Oracle7 networking products, such as SQL*Net.
See Also: "Network Administration" in Oracle7 Server Distributed Systems, Volume I.