21 xruigrant revocabon rules not standard many

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: om Bob for table X •  What privileges should Bob now have on table X? t1 t2 t3 19 Alice Carol Alice X (read,update,insert) X (read,update) Revoke X (read,update,insert) ? Bob Bob Bob {X:R,U,I} {X:R,U,I} Revoke Example 2 •  Alice gives Read, Update, Insert privileges to Bob for table X with Grant opBon •  Bob gives Read, Update privileges to Carol for table X •  Alice revokes all privileges from Bob for table X t1 t2 Alice Bob X (read,update,insert),grant X (read,update) Bob Carol {X:R,U,I} t3 Alice Revoke X (read,update,insert) Bob •  What privileges should Bob have on table X? •  What privileges should Carol have on table X? 20 {X:R,U,I} Revoke Example 3 •  Alice gives Read, Update, Insert privileges to Bob for table X with Grant opBon •  Bob gives Read, Update privileges to Carol for table X with Grant opBon •  Carol gives Read, Update privileges to Bob for table X •  Alice revokes all privileges from Bob for table X •  What privileges do Bob and Carol have now? t1 t2 X (read,update,i...
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