| I found it "You cannot create a trigger on table in the schema SYS." [message #371365] |
Fri, 06 October 2000 20:36 |
ChangHyun Bang
Messages: 5
Registered: October 2000
|
Junior Member |
|
|
I want trap when user logon.
Therefor, test SQL execute.
CREATE OR REPLACE TRIGGER login_acc
AFTER INSERT ON aud$
BEGIN
INSERT INTO login_info VALUES ('oracle','kmn-id',
TRUNC(SYSDATE));
END;
but oracle put message.
ORA-04089: cannot create triggers on objects owned by SYS.
Why object owned by SYS, therefore other method to trap, when user logon.
Thanks!
- winchild -
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
