This topic contains a solution. Click here to go to the answer

Author Question: Explain briefly what is meant by Schema in the context of database security, and how you might ... (Read 87 times)

faduma

  • Hero Member
  • *****
  • Posts: 528
Explain briefly what is meant by Schema in the context of database security, and how you might include it in a security plan.
 
  What will be an ideal response?

Question 2

Explain how you would use roles in setting up a database security system.
 
  What will be an ideal response?



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

kjohnson

  • Sr. Member
  • ****
  • Posts: 330
Answer to Question 1

In the context of database security, schema refers to the ownership of database objects. Users can be assigned to a schema much as they can be assigned to a role. Then permissions can be granted on the objects of the schema. The effect is much the same as using a role. In addition, schema can be assigned to roles, so that a role can contain both permissions and ownership of objects.

Answer to Question 2

Assigning permissions to individual users can be complex and hard to maintain. Roles allow you to create sets of related permissions that usually map to the ways various users work with the database. For example, a Human Resources role would contain all the permissions that those working in that department would need. Users can be dropped from or added to a role without needing to change the permissions.





 

Did you know?

Hypertension is a silent killer because it is deadly and has no significant early symptoms. The danger from hypertension is the extra load on the heart, which can lead to hypertensive heart disease and kidney damage. This occurs without any major symptoms until the high blood pressure becomes extreme. Regular blood pressure checks are an important method of catching hypertension before it can kill you.

Did you know?

The Food and Drug Administration has approved Risperdal, an adult antipsychotic drug, for the symptomatic treatment of irritability in children and adolescents with autism. The approval is the first for the use of a drug to treat behaviors associated with autism in children. These behaviors are included under the general heading of irritability and include aggression, deliberate self-injury, and temper tantrums.

Did you know?

Malaria was not eliminated in the United States until 1951. The term eliminated means that no new cases arise in a country for 3 years.

Did you know?

Stevens-Johnson syndrome and Toxic Epidermal Necrolysis syndrome are life-threatening reactions that can result in death. Complications include permanent blindness, dry-eye syndrome, lung damage, photophobia, asthma, chronic obstructive pulmonary disease, permanent loss of nail beds, scarring of mucous membranes, arthritis, and chronic fatigue syndrome. Many patients' pores scar shut, causing them to retain heat.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

For a complete list of videos, visit our video library