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
This note was uploaded on 02/27/2012 for the course IT 101 taught by Professor Unsure during the Spring '11 term at University of South Africa.
- Spring '11
- Computer Science