Pular para o conteúdo

› Fóruns › Banco de dados Oracle › auditar usuarios hora de logon e logoff no BD › auditar usuarios hora de logon e logoff no BD

17 de fevereiro de 2010 às 10:31 pm #92649
diegolenhardt
Participante

    Triggers,

    http://download.oracle.com/docs/cd/B105 … 8trigs.htm

    Mais especificamente os eventos:

    aí tem que testar USERENV(‘USER’)..

    Triggers on LOGON and LOGOFF Events

    LOGON and LOGOFF triggers can be associated with the database or with a schema. Their attributes include the system event and username, and they can specify simple conditions on USERID and USERNAME.

    * LOGON triggers fire after a successful logon of a user.
* LOGOFF triggers fire at the start of a user logoff.

    😉