create database csoma
character set utf8
collate utf8_hungarian_ci;
 
use csoma;
create table konyvek (
    az int not null primary key auto_increment,
    cim varchar(50),
    szerzo int,
    ar double
);
 
create user ervin@localhost;
create user kada@localhost;
create user naga@localhost;
create user monti@localhost;
 
set password for ervin@localhost = password('titok');
set password for kada@localhost = password('titok');
set password for naga@localhost = password('titok');
set password for monti@localhost = password('titok');
 
 
grant all privileges on csoma.konyvek to ervin@localhost;
grant all privileges on csoma.konyvek to kada@localhost;
grant select,update,insert, delete on csoma.konyvek to naga@localhost;
grant insert on csoma.konyvek to monti@localhost;