Ask Your Computer Question. Computer Experts Answer You ASAP.

(Not a Computer Question?)

What are the functions of a database administrator? How ...

Sent to Computer Experts May 15 2007 at 10:29 AM
   

What are the functions of a database administrator? How does he/she interact with other departments?


7)What types of controls are in place at your organization to limit access to the company's database?

Edited by Customer (name blocked for privacy) on May 15 2007 at 10:31 AM

 

Optional Information:
Browser: IE

Customer (name blocked for privacy)
Status:  Closed   Value: $8
Answer
May 15 2007 at 10:41 AM (11 minutes and 30 seconds later)
         
ACCEPTEDCheck Mark

Hello again,

Database Administrators (DBAs) perform many tasks. They are responsible for backing up the databases each day. They ensure security getting into the database. They create views and queries to get information from SQL databases for customers as well.

7) First, we use Windows NT authentication. Your login ID must be given specific rights to the server that the database resides on. Without access to the server a person cannot get to the DB. Secondly, each database has a specific password to open it. These are monitored by the DBAs. We also log who accesses a DB and monitor what queries were run. This ensures not only that the right people are in the Database, but that they are doing the right things!

Regards,
Ryan



If you found my help useful please don't forget to "Accept " A Bonus and Feedback is greatly appreciated
Ryan -- Computer Systems Analyst -- 100% Positive Feedback on 144 Computer Accepts
Bachelors in Computer Science, 10 yrs I.S. experience, troubleshooting, etc.
Think you can answer this question?
Login or Become an Expert

Related Answers

 

DISCLAIMER: You acknowledge that any information you may obtain from individuals you contact through use of the JustAnswer service comes from those individuals, not from JustAnswer, and that JustAnswer is not in any way responsible for any of the information these third parties may supply. The site and services are provided "as is" with no warranty and no representations are made regarding the qualification of an Expert. Responses and comments on JustAnswer are for general information and are not intended to substitute for informed professional advice (such as medical, legal, investment or accounting) and do not establish a professional-client relationship. JustAnswer is not intended or designed to address EMERGENCY QUESTIONS which should be directed immediately by telephone or in-person to qualified professionals. Please carefully read the Terms of Service.

JustAnswer > Computer Questions