Protect the confidentiality of highly sensitive grades

Assignment Help Computer Engineering

Reference no: EM133259602

Question: Imagine that the instruction team loads all of its grade data into a SQL database. The database is composed of a single table with the following schema:

StudentID, AssignmentID, PointsAwarded, PointsPossible

Professors want to protect the confidentiality of highly sensitive grades (e.g., this midterm), but they still need to grant their TAs access to other parts of the table. For example, they would like to give Jack, the MP2 grader, access to the rows where AssignmentID=MP2.

Which database security mechanism gives Professor Ren and Bates this ability?

Group of answer choices

Prepared Statements

Output Sanitization

Input Sanitization

View-Based Access Control

Reference no: EM133259602

Questions Cloud

What is the developer targeted spread : Describe "The Four Separate Stages in Financing a Real Estate Project" What is "The Developer's Targeted Spread" and what is its purpose

What else might have been considered : What else might have been considered in considering the literary theory? For example, would it make a difference to look at how the network changes across

Evaluate rita past and present marketing strategy : Rita Carmine, the owner and manager of Carmine's Italian Restaurant, is reviewing the slow growth of her restaurant. She's also thinking about the future and wo

Types of online advertising : Explain 2 different types of Online Advertising (outside of social media) that you would expect them to be engaging in and what they would be doing.

Protect the confidentiality of highly sensitive grades : CSC 380 Adelphi University Professors want to protect the confidentiality of highly sensitive grades (e.g., this midterm), but they still need to grant

What is generating the increase in hate : Dr. Kendi points out that racism has always existed in this country. Despite so much so-called progress, what is generating the increase in hate

Build and develop a content tree : You are a Digital Marketing Specialist, working with the marketing department for a furniture store called Lina Coevos (LC) - wholesale and retail. LC carries o

True of the achievement of boys and girls : Girls earn higher grades than boys regardless of SES. Girls tend to have higher grades at all grade levels. Boys tend to earn better writing grades than girls.

Intelligent operating system on the features : Consider a paragraph about A friendly, intelligent operating system on the features, you would like in an OS that knows your preferences and can talk to you

User Account

All Pages