Skip to Main Content

Logon Trigger

Prashant BondadaJan 31 2012 — edited Feb 1 2012
Hello,

We have an Oracle 10.2.0.3 database with PeopleSoft running on the server. The OS is Solaris 5.9.
For one particular SQL statement we are seeing ORA-01410 (Invalid ROWID) error, for which to generate a trace we would like to create a logon trigger as:

create or replace trigger sysadmlog
after logon
on sysadm.schema
begin
alter session set events '1410 trace name errorstack level 3';
end;
/

Some of our associates advice that, if the above created trigger becomes invalid then it may not allow new connections for SYSADM user to the database.

Please advice if creating LOGON Trigger(s) like above may have any impact on the database?

For any queries, kindly let me know.
Comments
Post Details
Added on Jan 31 2012
6 comments
553 views