The DBA is a special user who is created when the system is installed. DBA is a person (or persons) who is responsible for the management of the database. The DBA is responsible for the maintenance and smooth functioning of the system. Usually DBAs have all the powers that the system can give on all database objects and for all commands. He can pass most of these powers-the ones that he wishes-to other users of the system.
After the DBA, the next sets of users who have most powers on a database object (tables, views, etc.) are its owners. In many systems the user who creates a database object is its owner. A table owner or a view owner is usually given full privileges for the object that he owns. Like DBA, the owner of a database object can grant his power to other users. Users other than the special users mentioned above need explicit permission to perform any operation on a database object. These permissions are given using the GRANT command and taken away using the REVOKE command.
Each database requires at least one database administrator (DBA) to administer it. Because a database management 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 DBMS and application tools
Allocating system storage and planning future storage requirements for the database system
Enrolling users and maintaining system security
Controlling and monitoring user access to the database
Monitoring and optimizing the performance of the database (Performance tuning)
Planning for backup and recovery of database information
Backing up and restoring the database
No comments:
Post a Comment