Trigger je neplatny :(

Milan Sorm xsorm na informatics.muni.cz
Pátek Září 1 10:55:55 CEST 2000


Fri, Sep 01, 2000 ve 10:47:50AM +0200 Jan Serak napsal:
# Tak jinak:
# 
# $ oerr ORA 4098
# 04098, 00000, "trigger '%s' is invalid and failed re-validation"
# // *Cause: A trigger was attempted to be retrieved for execution and was
# //         found to be invalid.  This also means that compilation/authorization
# //         failed for the trigger.
# // *Action: Options are to resolve the compilation/authorization errors,
# //         disable the trigger, or drop the trigger.
# 
# Pokud tedy alter trigger ... compile; probehl dobre a bez chyb, je treba
# proverit druhou moznou pricinu. Nemanipuluje trigger s necim, na co nema
# pristupova prava (jine tabulky, sekvence,...)?

vola funkci a zapisuje do tabulky (a cte z te stejne). ale pod uzivatelem,
ktery ma prava ALTER ANY, SELECT ANY, INSERT ANY, UPDATE ANY atp.
ale budu se tim zabyvat a zkoumat, co se tam deje.

--milan


Další informace o konferenci Databases