oracle auto star suspection
after i login into oracle at scott user, immediately my own user defined programme like(tamil.sql) will run automatically (like autoexec.bat in dos). what sould do ?

Software/Hardware used:
ASKED: August 4, 2009  4:10 PM
UPDATED: August 4, 2009  4:37 PM

Answer Wiki:
I think you are talking about an AFTER LOGON trigger. You can define a trigger that will fire after connecting to the database. Here is an example: <pre>CREATE TABLE connection_audit ( login_date DATE, user_name VARCHAR2(30));</pre> <pre><b>CREATE OR REPLACE TRIGGER logon_audit AFTER LOGON ON DATABASE BEGIN INSERT INTO connection_audit (login_date, user_name) VALUES (SYSDATE, USER); END logon_audit; /</b></pre>
Last Wiki Answer Submitted:  August 4, 2009  4:37 pm  by  carlosdl   63,535 pts.
All Answer Wiki Contributors:  carlosdl   63,535 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _