Trigger je neplatny :(

[Jan Serak]

Milan Sorm wrote:
> 
> 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.

Moment. Stored procedure se provadi pod identifikaci vlastnika bez ohledu na
to, kdo ji provadi. Takze i kdyz uzivatel X, ktery ma INSERT ANY, provadi
storovanou proceduru, ktera patri vlastnikovi Y, tak pristupova prava
jsou taz, jako by ji primo spustil uzivatel Y.

							Jan Serak