Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- # warsztat
- GRANT ALL PRIVILEGES ON `warsztat_1`.* TO 'adm1_1'@'localhost' WITH GRANT OPTION
- GRANT SELECT, INSERT, UPDATE, DELETE ON `warsztat_1`.`klient` TO 'adm1_2'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `warsztat_1`.`czesc` TO 'adm1_2'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `warsztat_1`.`mechanik` TO 'adm1_2'@'localhost'
- GRANT SELECT (id_klient, nazwisko, imie) ON `warsztat_1`.`klient` TO 'adm1_3'@'localhost'
- GRANT SELECT (id_mechanik, nazwisko, imie) ON `warsztat_1`.`mechanik` TO 'adm1_3'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `warsztat_1`.`naprawa` TO 'adm1_3'@'localhost'
- GRANT SELECT (czesc, id_czesc, cena) ON `warsztat_1`.`czesc` TO 'adm1_3'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `warsztat_1`.`usluga` TO 'adm1_3'@'localhost'
- # przychodnia
- GRANT ALL PRIVILEGES ON `przychodnia_2`.* TO 'admin2_1'@'localhost' WITH GRANT OPTION
- GRANT SELECT, INSERT, UPDATE, DELETE ON `przychodnia_2`.`lekarz` TO 'admin2_2'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `przychodnia_2`.`pacjent` TO 'admin2_2'@'localhost'
- GRANT SELECT (nazwisko, id_pacjent, imie) ON `przychodnia_2`.`pacjent` TO 'admin2_3'@'localhost'
- GRANT SELECT (id_lekarz, nazwisko, imie) ON `przychodnia_2`.`lekarz` TO 'admin2_3'@'localhost'
- GRANT SELECT, INSERT, UPDATE, DELETE ON `przychodnia_2`.`wizyta` TO 'admin2_3'@'localhost'
- GRANT SELECT ON `przychodnia_2`.`wizyta` TO 'admin2_4'@'localhost'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement