Term papers writing service


Database security threats and countermeasures computer science essay

Privileges[ edit ] Two types of privileges are important relating to database security within the database environment: System Privileges[ edit ] System privileges allow a user to perform administrative actions in a database.

  1. Analysis can be performed to identify known exploits or policy breaches, or baselines can be captured over time to build a normal pattern used for detection of anomalous activity that could be indicative of intrusion. This ensures a certain level of segregation of duties that may provide evidence the native audit trails were not modified by authenticated administrators, and should be conducted by a security-oriented senior DBA group with read rights into production.
  2. For illustration, strong watchwords can be hard to retrieve and this may take to their being forgotten or written down and later stolen. Malicious internal onslaughts are frequently in the signifier of dissatisfied employees, who are out to do a net income from working the information within the database or want to do harm to a company by taking critical information.
  3. They may utilize exposures in package map or communicating protocols to be able to make this.

These include privileges as found in SQL Server such as: Databases fall under internal controls, that is, data used for public reporting, annual reports, etc. Typically, the role of the developer is to pass code to a DBA; however, given the cutbacks that have resulted from the economic downturn, a DBA might not be readily available.

Types of Database Vulnerability / Threats

If a DBA is not involved, it is important, at minimum, for a peer to conduct a code review. This ensures that the role of the developer is clearly separate. Another point of internal control is adherence to the principle of providing the least amount of privileges, especially in production. To allow developers more access to get their work done, it is much safer to use impersonation for exceptions that require elevated privileges e.

Please be aware, however, that DBAs must do all that is considered responsible because they are the de facto data stewards of the organization and must comply with regulations and the law. Testers attempt to find security vulnerabilities that could be used to defeat or bypass security controls, break into the database, compromise the system etc.

Database administrators or information security administrators may for example use automated vulnerability scans to search out misconfiguration of controls often referred to as 'drift' within the layers mentioned above along with known vulnerabilities within the database software. The results of such scans are used to harden the database improve security and close off the specific vulnerabilities identified, but other vulnerabilities often remain unrecognized and unaddressed.

In database environments where security is critical, continual monitoring for compliance with standards improves security.

Database security

Security compliance requires, amongst other procedures, patch management and the review and management of permissions especially public granted to objects within the database. Database objects may include table or other objects listed in the Table link. The permissions granted for SQL language commands on objects are considered in this process. Compliance monitoring is similar to vulnerability assessment, except that the results of vulnerability assessments generally drive the security standards that lead to the continuous monitoring program.

Essentially, vulnerability assessment is a preliminary procedure to determine risk where a compliance program is the process of on-going risk assessment.

The compliance program should take into consideration any dependencies at the application software level as changes at the database level may have effects on the application software or the application server. Abstraction[ edit ] Application level authentication and authorization mechanisms may be effective means of providing abstraction from the database layer.

Navigation menu

The primary benefit of abstraction is that of a single sign-on capability across multiple databases and platforms. A single sign-on system stores the database user's credentials and authenticates to the database on behalf of the user. Database activity monitoring DAM [ edit ] Another security layer of a more sophisticated nature includes real-time database activity monitoringeither by analyzing protocol traffic SQL over the network, or by observing local database activity on each server using software agents, or both.

Use of agents or native logging is required to capture activities executed on the database server, which typically include the activities of the database administrator. Agents allow this information to be captured in a fashion that can not be disabled by the database administrator, who has the ability to disable or modify native audit logs. Analysis can be performed to identify known exploits or policy breaches, or baselines can be captured over time to build a normal pattern used for detection of database security threats and countermeasures computer science essay activity that could be indicative of intrusion.

Some systems are designed to support separation of duties SODwhich is a typical requirement of auditors. This requires the DAM audit trail to be securely stored in a separate system not administered by the database administration group. Native audit[ edit ] In addition to using external tools for monitoring or auditing, native database audit capabilities are also available for many database platforms.

This ensures a certain level of segregation of duties that may provide evidence the native audit trails were not modified by authenticated administrators, and should be conducted by a security-oriented senior DBA group with read rights into production.

Turning on native impacts the performance of the server. Process and procedures[ edit ] A good database security program includes the regular review of privileges granted to user accounts and accounts used by immediate processes. For individual accounts a two-factor authentication system improves security but adds complexity and cost.

Accounts used by automated processes require appropriate controls around password storage such as sufficient encryption and access controls to reduce the risk of compromise. In conjunction with a sound database security program, an appropriate disaster recovery program can ensure that service is not interrupted during a security incident, or any incident that results in an outage of the primary database environment.

An example is that of replication for the primary databases to sites located in different geographical regions.