Pular para o conteúdo

› Fóruns › Banco de dados Oracle › RESOLVIDO – Trigger de Auditoria não realiza o gatilho › RESOLVIDO – Trigger de Auditoria não realiza o gatilho

9 de dezembro de 2010 às 8:18 pm #97242
Susu
Participante

    ACHO QUE ACHEI O PROBLEMA.
    http://download.oracle.com/docs/cd/B141 … m#i2153503

    TENHO Q CRIAR CONECTADO COMO SYSTEM. EU SÓ TENHO ROLE DE DBA. PARA MIM A ROLE DE DBA DAVA ACESSO A TUDO.

    Prerequisites
    Before a trigger can be created, the user SYS must run a SQL script commonly called DBMSSTDX.SQL. The exact name and location of this script depend on your operating system.

    •To create a trigger in your own schema on a table in your own schema or on your own schema (SCHEMA), you must have the CREATE TRIGGER system privilege.

    •To create a trigger in any schema on a table in any schema, or on another user’s schema (schema.SCHEMA), you must have the CREATE ANY TRIGGER system privilege.

    •In addition to the preceding privileges, to create a trigger on DATABASE, you must have the ADMINISTER DATABASE TRIGGER system privilege.