create user webuser_%dbname% with password 'fGRgr_Gmp455x' ;
grant %dbname%_web to webuser_%dbname% ;
ALTER USER webuser_%dbname% WITH PASSWORD 'nouveau_mot_de_passe';

create user webuser_%dbname% with password 'pwd2Define!';
grant select on pays to webuser_%dbname% ;
grant select on detailbien_t to webuser_%dbname% ;
grant select on bien_t to webuser_%dbname% ;
grant select on htmlbien_t to webuser_%dbname% ;
grant select on photo_t to webuser_%dbname% ;
grant select on prospectbien_t to webuser_%dbname% ;
grant select on prospect_t to webuser_%dbname% ;
grant select on typchauf  to webuser_%dbname% ;
grant select on typmeta  to webuser_%dbname% ;
grant select on typ  to webuser_%dbname% ;
grant select on region  to webuser_%dbname% ;
grant select on regionmeta  to webuser_%dbname% ;
grant select on style to webuser_%dbname% ;
grant select on disponibilite to webuser_%dbname% ;
grant select on typcuisine to webuser_%dbname% ;
grant select on environnement to webuser_%dbname% ;
grant select on etat to webuser_%dbname% ;
grant select on environnement to webuser_%dbname% ;
grant select on naturebien to webuser_%dbname% ;
grant select on preference to webuser_%dbname% ;
grant select on preference_t to webuser_%dbname% ;
grant select on agence to webuser_%dbname% ;
grant select on langue to webuser_%dbname% ;
grant select on polit to webuser_%dbname% ;
grant select on typrelation to webuser_%dbname% ;
grant select on typmandat to webuser_%dbname% ;
grant select on typdetail to webuser_%dbname% ;
grant select on detail to webuser_%dbname% ;
grant select on utilisateur to webuser_%dbname% ;
grant select on htmlpage to webuser_%dbname% ;
grant select on prospectbien_t to webuser_%dbname% ;
grant select on prospectbien to webuser_%dbname% ;
grant select on statutbien to webuser_%dbname% ;
