#17
CREATE USER operator IDENTIFIED BY '123';
CREATE USER instruktor IDENTIFIED BY '123';
CREATE USER gracz;

grant all privileges on *.* to 'operator';
grant insert on *.* to 'instruktor';
grant create on *.* to 'gracz';

SHOW GRANTS FOR operator;

REVOKE ALL PRIVILEGES on *.* from operator;

#18
CREATE USER 'uczen1';
use mysql;
show tables;
select *from user;
set password for uczen1='uczen1';

create user 'user1';
create user 'user2';
create user 'user3';
create user 'root2';

grant all privileges on transakcje.* to 'user3';
grant all privileges on *.* to 'root2' with grant option;

create database db1;
create database db2;

grant all privileges on db1.* to 'user1';
grant all privileges on db2.* to 'user2';

set password for user1='user';
grant usage on db2.* to user2 identified by 'user';

create database db3;

revoke all privileges on db3.* from user3;

use db1;

create table dby1 (
c1 int auto_increment primary key,
c2 varchar(50)
);

create table dby1_2 (
c3 int auto_increment primary key,
c4 varchar(25)
);

use db2;

create table dby2 (
x1 int auto_increment primary key,
x2 varchar(50)
);

create table dby2_2 (
x3 int auto_increment primary key,
x4 varchar(25)
);

grant select, insert, update, delete on db2.dby2 to 'user1';
grant select(x3) on db2.dby2_2 to 'user1';
grant all privileges on db2.* to 'user2';

show grants for user1;
show grants for user2;
show grants for user3;
show grants for root2;

create database firma;
use firma;

create table pracownicy (
id_pracownika int primary key,
Imie varchar(50),
Nazwisko varchar(50),
);

create table place (
id_placy int primary key,
placa int
);

create table magazyn (
id_magazynu int primary key,
nazwa varchar(50),
ilosc int,
oddzial varchar(10)
);

create user kadrowa;
create user ksiegowa;
create user magazynier;
create user informatyk;
create user prezes;

grant all privileges on firma.pracownicy to 'kadrowa';
grant select on firma.place to 'kadrowa';
grant select on firma.pracownicy to 'ksiegowa';
grant all privileges on firma.place to 'ksiegowa';
grant select on firma.magazyn to 'ksiegowa';
grant all privileges on firma.magazyn to 'magazynier';
grant all privileges on firma.* to 'informatyk' with grant option;
grant select on firma.* to 'prezes';