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

Like it on Facebook, Tweet it or share this article on other bookmarking websites.

Comments (0)

There are no comments posted here yet

Which is the worst ever thing invented by man?

Which is the worst ever thing or system invented by man?
No answer selected. Please try again.
Please select either existing option or enter your own, however not both.
Please select minimum 0 answer(s) and maximum 6 answer(s).
[{"id":"22436","title":"Atom Bomb","votes":"29","type":"x","order":"1","pct":48.33,"resources":[]},{"id":"22437","title":"Plastic ","votes":"22","type":"x","order":"2","pct":36.67,"resources":[]},{"id":"22438","title":"Automobiles","votes":"1","type":"x","order":"3","pct":1.67,"resources":[]},{"id":"22439","title":"Agriculture","votes":"3","type":"x","order":"4","pct":5,"resources":[]},{"id":"22440","title":"Construction Technology","votes":"3","type":"x","order":"5","pct":5,"resources":[]},{"id":"22441","title":"Any other not mentioned here...","votes":"2","type":"x","order":"6","pct":3.33,"resources":[]}] ["#ff5b00","#4ac0f2","#b80028","#eef66c","#60bb22","#b96a9a","#62c2cc"] ["rgba(255,91,0,0.7)","rgba(74,192,242,0.7)","rgba(184,0,40,0.7)","rgba(238,246,108,0.7)","rgba(96,187,34,0.7)","rgba(185,106,154,0.7)","rgba(98,194,204,0.7)"] 350
bottom 200
No married couple wants to end up getting divorced. It is not like they have planned for it. They try to put up with their partners for as long as they
Due to our modern lifestyle, we feel that digestion related disorders are a common problem. Thus, we neither give importance to them nor seek any help
The bond of marriage brings the two people together. Initially, everything may seem okay and both of them slowly start discovering each other in the journey.
Introduction:  The oracle database server is an object-relational database management system. This write-up deals with practical aspects of compatibility
Hello and Welcome back to SQL beginners tutorial part 2. In the previous article, as a first part in the series we learnt till how to insert the data in
This Whole world is running because of data and its increasing at an exponential rate. You have data around you everywhere and all the time. Even your
A database is a logically coherent collection of data with some inherent meaning, representing some aspect of real world and which is designed, built and
It is a collection of programs that enables user to create and maintain a database. In other words it is general-purpose software that provides the users