This preview shows page 1. Sign up to view the full content.
Unformatted text preview: 5. Download the prac2.sql file from the COS 326 page, and run the script. 6. Grant access to the tblbuilding to the university group. Can you revoke the access of the cs role of this table? 7. Grant access to the tblvenue to academic_program . 8. Revoke the access right of stuku to tblvenue . 9. Set the current session role to that stuku and try to access the tblvenue table. Could you access the table? 10. Restore the original privilege states....
View Full Document
- Spring '11
- Computer Science