[ Milos D @ 01.03.2005. 13:37 ] @
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; |