Suppose a table Student ( ( sid , , name, sex, age, dept ) . ) .
Fantastic news! We've Found the answer you've been seeking!
Question:
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?
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date: