Re: logon trigger for special user

DA Morgan wrote:
> Kitty wrote:
>
>> I have to create a trigger which fires every time special users are
>> connecting into database. When one of these users is connected, the
>> trigger has to insert session_ID, date and table_name (name of the
>> table, this special user is logged on) in a table named
>> Log_on_table. My problem is that I don't know how to get the
>> session_id and the table_name.
>>
>> CREATE OR REPLACE Trigger Log_on_Trigger
>> AFTER LOGON Database
>> Begin
>> If (sys.login_user in (‘user1', ‘user2') then
>> INSERT INTO Log_on_table (??session_ID??, sysdate,
>> ??table_name??)
>> End If
>> End
>>
>> I have not tested this code jet, so I don't know if it works
>> correctly.
>>
>> Thanks for helping me!!!!
>
> http://www.psoug.org
> click on Morgan's Library
> click on DDL Triggers
> click on System Triggers

Daniël,

I don't know whether it makes much of a difference, but it might be confusing:
Both your DDL Triggers and your System Triggers page is labeled '10g', while the index for both on the Morgan's Library page is labeled '9i'.

-- 
Jeroen.