Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Suppose a table Student ( ( sid , , name, sex, age, dept ) . ) . write the SOL statements to achieve the following:a
Suppose a table Student(sid, name, sex, age, dept). write the SOL statements to achieve the following:a. Grant the user U1 the privilege to retrieve any information from the table Student.b. Grant the user U2 the privilege to retrieve any information and modify the student ID from the table Student.c. Grant the user U3 the privilege to insert tuples into the table Student and allow him to grant this privilege to other users.d. Grant the user U4 the privilege to retrieve only the (sid, name, age) attributes from table Student for students with dept=IT.e. Revoke the privilege for user U2 to modify the student ID in the table Student.f. Grant the user U5 the privilege to modify only the age attribute of student and allow him to grant this privilege to other users.g. U5 wants to allow U6 to modify the age attribute of student.h. Revoke the privilege for user U5 to modify only the age attribute of student. I. Can U6 be able to modify the age attribute now? Why?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
glad to create a response that addresses the prompt incorporating the strengths of Response A and Response B while rectifying any shortcomings based on the ratings SQL Statements for Granting and Revo...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started