create view
        custview
          (firstname, lastname, company, city)
    as
    select fname, lname, company, city
    from customer
    where city = "Redwood City"
    with check option;

grant delete, insert, select, update
    on custview
    to public;