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:
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>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
