CSC 440 – Database Management Systems
Quiz #6
Student Name: Score:_________________
Assume Janeway owns the following tables:
Movie (title, year, length, inColor, studioName, producerC#)
Studio (name, address, presC#)
(a) (3 points) Suppose Janeway would like to give SELECT and INSERT privileges to Kirk on
Studio. Janeway would also like Kirk to give these privileges to others if necessary. Write the
SQL statement for Janeway.
GRANT SELECT, INSERT ON Studio TO kirk WITH GRANT OPTION;
(b) (3 points) Kirk later decides to give SELECT privilege on Studio to Picard, but he doesn’t
want Picard to give the privilege to others. Write the SQL statement for Kirk.
GRANT SELECT ON Studio TO Picard;
(c) (4 points) Draw the grant diagram.
Janeway
Select on
Studio**
Kirk
Select on
Studio*
Picard
Select on
Studio
Janeway
Insert on
Studio **
Kirk
Insert on
Studio*
