Carol and we allow them to update their e mail

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: rk around this) –  not implemented for select in Oracle –  implemented in MySQL 13 CreaBng Views •  Careful with definiBons! –  A subset of the database to which a user has access, or: –  A virtual table created as a “shortcut” query of other tables •  View syntax: create view view_name as query_definition; •  Querying views is nearly idenBcal to querying regular tables 14 View- Based Access Control •  AlternaBve method to grant Carol access to name and email columns: create view employee_public as select name,email from employee; grant select on employee_public to carol; 15 Row- Level Access Control •  Suppose we also allow employees to view their own ssn, salary: create view employee_Carol as select * from employee where name='Carol'; grant select on employee_Carol to carol; •  And we allow them to update their e- mail addresses:...
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