For each of the following, write SQL statements to create views where needed and to grant...

Transcribed Image Text:

For each of the following, write SQL statements to create views where needed and to grant the indicated privileges for the University database with this schema: Student(stuld, lastName, firstName, major, credits) Class(classNumber, facld, schedule, room) Enroll(stuld, classNumber, grade) a. Give permission to read the tables Student and Class to user 201. b. Create a view of Enroll that does not include the grade attribute, and give user 201 permission to read and update the view. \ For each of the following, write SQL statements to create views where needed and to grant the indicated privileges for the University database with this schema: Student(stuld, lastName, firstName, major, credits) Class(classNumber, facld, schedule, room) Enroll(stuld, classNumber, grade) a. Give permission to read the tables Student and Class to user 201. b. Create a view of Enroll that does not include the grade attribute, and give user 201 permission to read and update the view. \

Answer rating: 100% (QA)

To grant permissions and create views in the University database with the given schema you can use S... View the full answer