create view ADDRESS_VIEW (CITY) as select CITY from ADDRESS; create role testrole;