Napravim novi login, user i role. Dodjelim user roli i onda pokusam ograniciti role-u:
GRANT SELECT ON table_name TO role_name;
Ali kad pokušam izvesti naredbu:
DELETE FROM table_name WHERE id=1
onda se uredno obrise odgovarajuci redak. Pokusala sam staviti i:
DENY DELETE ON table_name TO role_name
no ni to nije pomoglo. Zna li neko u cemu gresim?