create database torony
character set utf8
collate utf8_hungarian_ci;
 
use torony;
create table termekek (
    az int not null primary key auto_increment,
    nev varchar(50),
    darab int,
    ar double
);
 
create user hanka@localhost;
create user holda@localhost;
create user izora@localhost;
create user judit@localhost;
 
set password for hanka@localhost = password('type');
set password for holda@localhost = password('type');
set password for izora@localhost = password('type');
set password for judit@localhost = password('type');
 
 
grant select on torony.termekek to hanka@localhost;
grant all privileges on torony.termekek to holda@localhost;
grant select,update,insert, delete on torony.termekek to izora@localhost;
grant insert on torony.termekek to judit@localhost;