Por que não posso criar gatilhos em objetos pertencentes a SYS?
Ao tentar criar um gatilho chamadoghazal_current_bef_upd_row
:
create trigger ghazal_current_bef_upd_row
before update on ghazal_current
for each row
when (new.Rating < old.Rating)
begin
insert into ghazal_current_audit
(GhazalName,Old_Rating,New_Rating)
values
(:old.GhazalName,:old.Rating,:new.Rating);
end;
Estou tendo o erro a seguir :
Error report:
ORA-04089: cannot create triggers on objects owned by SYS
04089. 00000 - "cannot create triggers on objects owned by SYS"
*Cause: An attempt was made to create a trigger on an object owned by SYS.
*Action: Do not create triggers on objects owned by SYS.
Ambas as tabelas nomeadasghazals_current
eghazal_current_audit
foram criados porSYS
. Por que não consigo criar um gatilho na tabela criada porSYS
.