Pretpostavka ti nije tacna :)
Ovaj problem za da ogranicis korisnike po zapisu se resava ovako:
Code:
// Kreiras baznu tabelu:
CREATE TABLE primer(
data VARCHAR(10),
user_name CHAR(31)
)
CREATE TRIGGER "user_ins" FOR primer ACTIVE BEFORE INSERT POSITION 0
AS
BEGIN
new.user_name = CURRENT_USER;
END;
CREATE VIEW vprimer AS SELECT data FROM primer WHERE CURRENT_USER = user_name;
i sada posto imamo tabelu koja ima sve recorde, i imamo view koji ogranicava korisnike da update/delete/select recorde drugih korisnika, samo treba da dodelime privilegije usera da select/insert/update view.
znaci sada ti treba
GRANT ALL ON primer TO vprimer;
GRANT ALL ON vprimer TO public;
u ovom slucaju svako moze dirati samo svoje recorde. ako zelis da useri vide zapise drugih usera onda samo dodas:
GRANT SELECT ON primer TO public;
Ako eventualno ne zelis da useri znaji ko poseduje zapis onda uradis nov view bez kolone user_name ... i tako dalje :)
People who think they know everything tend to irritate those of us who do.