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 88 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?

Most fungi that pathogenically affect humans live in soil. If a person is not healthy, has an open wound, or is immunocompromised, a fungal infection can be very aggressive.

Did you know?

In ancient Rome, many of the richer people in the population had lead-induced gout. The reason for this is unclear. Lead poisoning has also been linked to madness.

Did you know?

Vaccines prevent between 2.5 and 4 million deaths every year.

Did you know?

Only one in 10 cancer deaths is caused by the primary tumor. The vast majority of cancer mortality is caused by cells breaking away from the main tumor and metastasizing to other parts of the body, such as the brain, bones, or liver.

Did you know?

Human neurons are so small that they require a microscope in order to be seen. However, some neurons can be up to 3 feet long, such as those that extend from the spinal cord to the toes.

For a complete list of videos, visit our video library