








GRANT ALTER, DELETE, SELECT ON opilane
TO db_geniusdarja
GRANT tegevused
select * from opilane;
alter table opilane add aasta int;
delete from opilane
where id=1;

Mitte lubatud tegevused
INSERT INTO opilane(id, nimi, vanus)
VALUES(5, 'NONE', 25)

GRANT ALTER, DELETE, SELECT ON opilane
TO db_geniusdarja
select * from opilane;
alter table opilane add aasta int;
delete from opilane
where id=1;
INSERT INTO opilane(id, nimi, vanus)
VALUES(5, 'NONE', 25)