Kasutajate õigused

create table auto(    autoID int not null primary key AUTO_INCREMENT,    mudel varchar(20),    mark varchar(20),    varv varchar(10),    v_aasta int);    SELECT * from auto;INSERT INTO `auto` (`autoID`, `mudel`, `mark`, `varv`, `v_aasta`) VALUES (NULL, ‘X5’, ‘BMW’, ‘valge’, ‘2000’);CREATE USER ‘opilaneKemppi’@’localhost’ IDENTIFIED VIA mysql_native_password USING ‘***’;GRANT USAGE ON *.* TO ‘opilaneKemppi’@’localhost’ REQUIRE NONE WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0;  CREATE USER ‘opilaneKemppi’@’localhost’GRANT USAGE ON *.* TO ‘opilaneKemppi’@’localhost’GRANT – назначение прав пользователяGRANT SELECT ON `autod_kemppi`.`auto` TO ‘opilaneKemppi’@’localhost’;  Create table klient(    klientID int PRIMARY KEY AUTO_INCREMENT,    eesnimi varchar(10),    perenimi varchar(10) not null,    telefon char(12)    )Use autod_kemppi;insert into klient(eesnimi,perenimi)VALUES (‘test’,’test’);Insert into auto(mudel, mark, varv, v_aasta)       values (‘x1’,‘Volvo’,‘sinine’,2003) Security -> Login(New Login)