Print

Types of Oracle Users

Sameer
Written by Sameer. Posted in Oracle on 23 August 2009.
Hot 1734 hits 0 favoured

 

The types of users and their roles and responsibilities at a site can vary. 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.
There are following types of users:

1.    Database Administrators
2.    Security Officers
3.    Network Administrators
4.    Application Developers
5.    Application Administrators
6.    Database Users

Database Administrators:

Each database requires at least one database administrator (DBA) to administer it. Because an Oracle database system can be large and can have many users, often this is not a one person job. In such cases, there is a group of DBAs who share responsibility.

A database administrator’s responsibilities can include the following tasks:
-    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 (table spaces) 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
-    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

Security Officers:

A security officer enrolls users, controls and monitors user access to the database, and maintains system security.

Network Administrators:

A network administrator can administer Oracle networking products, such as Oracle Net.

Application Developers:

Application developers design and implement database applications. Their 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:

Application administrators administrate a particular application. Each application can have its own administrator.

Database Users:

Database users interact with the database through applications or utilities. A typical user’s responsibilities include the following tasks:

-    Entering, modifying, and deleting data, where permitted
-    Generating reports from the data

Sameer

Author: Sameer

101 5085 0
.............
  • No comments found
Powered by CjBlog