Security and integrity, Database Management System

Assignment Help:

Security And Integrity

After Reading the concepts of database recovery in the last section, let us now deal with a vital concept that helps in minimizing consistency errors in database systems. These are the concepts of database integrity and security.

Information security is the protection of information against unauthorised disclosure, destruction or alteration.  Database security is the protection of information that is keeps in a database.  It deals with ensuring only the "right people" get the right to access the "right data".  By right people we mean those people who have the right to update / access the data that they are requesting to update / access with the database.

This should also make sure the confidentiality of the data.  For instance, in an educational institution, information about a student's grades should be made available only to that student, while only the university authorities should be able to update that information. Likewise, personal information of the employees should be accessible only to the authorities concerned and not to everyone.  Another instance can be the medical records of patients in a hospital. These should be available only to health care officials.

Therefore, one of the concepts of database security is primarily a specification of access rules about who has what type of access to what information. This is also called as the problem of Authorisation.  These access rules are defined at the time database is described.  The person who writes access rules is known as the authoriser.  The process of guaranteed that information and other protected objects are accessed only in authorised ways is known as access control. There may be other forms of security relating to operating system, physical, communication aspects of databases. Though, in this unit, we will confine ourselves mainly to authorisation and access control using easy commands.

The term integrity is also applied to data and to the mechanism that helps to make sure its consistency.  Integrity shows to the avoidance of accidental loss of consistency. Protection of database contents from unauthorised access contains legal and ethical issues, organization policies and database management policies.  To protect database various levels of security measures are maintained:

 1)  Physical:  The site or sites having the computer system must be physically secured against illegal entry of unauthorised persons.

2)  Human: An approval is given to a user to decrease the chance of any information leakage and unwanted manipulations.

3)  Operating System: Even though foolproof security methods are taken to secure database systems, weakness in the operating system security might serve as a means of unauthorised access to the database.

4)  Network:  Since databases permit distributed or remote access by terminals or network, software level security within the network software is a main issue.

5)  Database system: The data items in a database require a fine level of access control. For instance, a user may only be permitted to read a data item and is permitted to issue queries but would not be permitted to deliberately change the data. It is the responsibility of the database system to make sure that these access restrictions are not violated.

To make sure database security needs implementation of security at all the levels as above. The Database Administrator (DBA) is responsible for executing the database security policies in a database system. The organisation or data owners make these policies. DBA makes or cancels the user accounts assigning appropriate security rights to user accounts as well as power of granting and revoking certain privileges further to other users.


Related Discussions:- Security and integrity

Define the canonical cover, Define the Canonical cover Ans: A canonical...

Define the Canonical cover Ans: A canonical cover F c for F is a set of dependencies like F logically implies all dependencies in F c , and F c logically entails all dependen

What is called remapping of bad sectors, What is called remapping of bad se...

What is called remapping of bad sectors? If the controller detects that a sector is injured when the disk is initially formatted, or when an attempt is made to write the secto

Column constraints, Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY K...

Column Constraints: NOT NULL, UNIQUE, CHECK, PRIMARY KEY, DEFAULT, REFERENCES, On  delete  Cascade :  Using  this  key  whenever  a  parent  row  is  removed  in  a referenced

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo...

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Display how records can be deleted and updated in qbe, With the help of an ...

With the help of an example display how records can be deleted and updated in QBE. (i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%. (ii) Delete employee

Describe the composite key, Describe the Composite Key Composite Key: ...

Describe the Composite Key Composite Key: Sometimes one key is not enough to uniquely recognize a row. E.g. in a single class Roll is enough to search a student, but in the w

Key, Q.   Explain the terms key constraints participation constraints and m...

Q.   Explain the terms key constraints participation constraints and mapping caradinalities in ER model.  Participation Constraints :   The participation of an entity set E i

Abap/4 program, It is not possible to make an ABAP/4 program, which having ...

It is not possible to make an ABAP/4 program, which having only Subroutines. False. We can make ABAP/4 program, which having only Subroutines.

Explain the deadlock avoidance, Define deadlock avoidance. An alternat...

Define deadlock avoidance. An alternative method for avoiding deadlocks is to needs additional information about how resources are to be requested. Each request requires the s

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd