Õpimap norem tarkvararendaja, Aleksandr Nadvornõi

Создать БД MovieBase, внутри БД создать таблицу movies (id, moviesNimi, moviesYear, movieDir и movieCost).

таблицу guest(id, name)

Заполнить таблицы 7 записями.

Создать пользователя DirectorNimi, пароль director с правами 

1. на просмотр и обновление данных в таблице movies полях movieDir и movieCost + 1 своя привелегия,

2. на просмотр и добавление записей в таблице guest. 

Tabeli movies lisamine

insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘Bullet Train’, 2022, ‘David Leitch’, 9);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘Terrifier’, 2016, ‘Damien Leone’, 0,04);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(’12 Monkeys’, 1995, ‘Terrence Vance’, 29,5);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘Lock, Stock and Two smoking Barrels’, 1998, ‘Guy Ritchie’, 25);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘The Silence of the Lambs’, 1991, ‘Jonathan Demme’, 19);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘Law Abiding Citizen’, 2009, ‘Felix Gary Gray’, 53);
insert into movies (moviesNimi, moviesYear, movieDir, movieCost)
values(‘The Gentlemen’, 2019, ‘Guy Ritchie’, 22);

Tabeli guest lisamine

INSERT INTO guest(name)
VALUES(‘Ben Afflek’);
INSERT INTO guest(name)
VALUES(‘Marina Gorbunova’);
INSERT INTO guest(name)
VALUES(‘Klark Kent’);
INSERT INTO guest(name)
VALUES(‘Peter Parker’);
INSERT INTO guest(name)
VALUES(‘Irina Merkulova’);
INSERT INTO guest(name)
VALUES(‘Marie Curie’);
INSERT INTO guest(name)
VALUES(‘Ostap Bender’);

Kasutaja director loomine

piirangute lisamine

Piiranute kontrollimine movies tabelis

Piiranute kontrollimine guest tabelis