LF 8.3 Benutzer und Berechtigung

CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';

GRANT ALL PRIVILEGES ON antique . * TO 'admin'@'localhost';

CREATE USER 'Luka Kovacevic'@'localhost' IDENTIFIED BY 'passwort';

GRANT Drop, Delete, Update, Select, Insert, Create ON antique . * TO 'Luka Kovacevic'@'localhost';

CREATE USER 'Timo Krug'@'localhost' IDENTIFIED BY '12345678';

GRANT Update, Select, Insert ON antique . * TO 'Timo Krug'@'localhost';

CREATE USER 'Florian Haag'@'localhost' IDENTIFIED BY '12345678';

GRANT Select ON antique . * TO 'Florian Haag'@'localhost';

CREATE USER 'Hannes Pongratz'@'localhost' IDENTIFIED BY 'HmPTP2000';

GRANT Select ON antique . * TO 'Hannes Pongratz'@'localhost';