Schema logon trigger for external user

I have an external user called OPS$DOM1\appuser, i.e. it's a Windows user called appuser in domain DOM1. appuser can do sqlplus / with no problems so the authentication is fine.

I want to setup a schema logon trigger for this user, so I tried:

CREATE OR REPLACE TRIGGER
     AFTER LOGON ON OPS$DOM1\APPUSER.SCHEMA BEGIN END; This doesn't work because '\' is an invalid character, so I tried "OPS$DOM1\APPUSER.SCHEMA", "OPS$DOM1\APPUSER".SCHEMA etc. - no good. Does anyone know how I can do this?

Oracle 9.2.0.1, Windows XP.

Thanks
Martin Chatfield Received on Sun Apr 10 2005 - 05:03:16 CDT