create database csali
character set utf8
collate utf8_hungarian_ci;

use csali;
create table dolgozok (
    az int not null primary key auto_increment,
    nev varchar(50),
    telepules varchar(50),
    fizetes double
);

create user dani@localhost;
create user peti@localhost;
create user lali@localhost;
create user imre@localhost;

set password for dani@localhost = password('titok');
set password for peti@localhost = password('titok');
set password for lali@localhost = password('titok');
set password for imre@localhost = password('titok');


grant select,update on csali.dolgozok to dani@localhost;
grant all privileges on csali.dolgozok to peti@localhost;
grant select,update,insert on csali.dolgozok to lali@localhost;
grant insert on csali.dolgozok to imre@localhost;