create databank DB of 10 pages in 'db' with log option;

create schema UINFO;

create table UINFO.USER_INFO (
	IDENT_NAME	char(128) primary key,
	FULL_NAME	char(60),
	PHONE		char(30)
);

create ident USER_INFO_ACCESS_GROUP as group; 
create ident USER_INFO_MODIFY_GROUP as group;

create view UINFSER_INFO_ACCESS as
select IDENT_NAME,FULL_NAME,PHONE from UINFO.USER_INFO;
grant select on UINFO.USER_INFO_ACCESS to USER_INFO_ACCESS_GROUP;

create view UINFO.USER_INFO_MODIFY as
select IDENT_NAME,FULL_NAME,PHONE from UINFO.USER_INFO 
where IDENT_NAME=user;
grant select on UINFO.USER_INFO_MODIFY to USER_INFO_MODIFY_GROUP;
grant update(PHONE) on UINFO.USER_INFO_MODIFY to USER_INFO_MODIFY_GROUP;