T1 t2 t3 19 alice carol alice x readupdateinsert

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: grant update(email) on employee_Carol to carol; –  (Or create yet another new view…) 16 DelegaBng Policy Authority •  grant privilege_list on resource to user_list with grant option; •  Allows other users to grant privileges, including “with grant opBon” privileges •  Like “Copy right” from Access Control lecture •  Can grant subset privileges too –  Alice: grant select on table1 to bob with grant option; –  Bob: grant select(column1) on table1 to carol with grant option; 17 SQL revoke Syntax •  revoke privilege_list on resource from user_list; •  What happens when a user is granted access from two different sources, and one is revoked? •  What happens when a “with grant opBon” privilege is revoked? •  RevocaBon with granBng is tricky business… 18 Revoke Example 1 •  Alice gives Read, Update, Insert privileges to Bob for table X •  Carol gives Read, Update privileges to Bob for table X •  Alice revokes Read, Update, Insert privileges fr...
View Full Document

This note was uploaded on 02/03/2014 for the course ECE 422 taught by Professor Nicol during the Fall '08 term at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online