Firebird, DELETE ... WHERE zahteva SELECT permission?
Zdravo svima,
Da li moram da dodelim SELECT permission za tabelu T da bi korisnik mogao da uradi:
DELETE FROM T WHERE ID=5
Ako dodelim samo DELETE (i REFERENCES) permission, ne dozvoljava izvrsavanje ove naredbe. A dozvoljava da obrisem celu tabelu sa DELETE FROM T... Inace, korisnici vide podatke preko pogleda, ali posto pogled poziva nekoliko tabela ne mogu da brisem pomocu njega.
Hvala unapred.
sledi SQL log:
Database: somedb, User: peter, Role: ROLE_USER
SQL>
SQL>
SQL> show table t;
ID INTEGER Not Null
CONSTRAINT PK_T:
Primary key (ID)
SQL>
SQL> show grants t;
GRANT DELETE, REFERENCES ON T TO USER PETER
SQL>
SQL> delete from t where id = 2;
Statement failed, SQLCODE = -551
no permission for read/select access to TABLE T
SQL> delete from t;
SQL> rollback;
 |  |
 |
