Imam jedan poprilicno banalan problem, koji nikako ne mogu da rijesim. Zelim dati korisniku SELECT only prava na jednoj tabeli, dok na ostatku baze treba imati puna prava.
Code:
GRANT ALL PRIVILEGES ON baza.* TO 'korisnik'@'localhost' IDENTIFIED BY 'pass';
REVOKE ALL PRIVILEGES ON baza.test FROM 'korisnik'@'localhost';
GRANT SELECT ON baza.test TO 'korisnik'@'localhost' IDENTIFIED BY 'pass';
GRANT ALL PRIVILEGES ON baza.* TO 'korisnik'@'localhost' IDENTIFIED BY 'pass';
REVOKE ALL PRIVILEGES ON baza.test FROM 'korisnik'@'localhost';
GRANT SELECT ON baza.test TO 'korisnik'@'localhost' IDENTIFIED BY 'pass';
Iz nekog razloga, ovo ne radi, korisnik uvek ima puna prava na "test" tabeli. Ocito sam promasio nesto?
Hvala