Home » RDBMS Server » Server Administration » Can't create trigger. help me!
Can't create trigger. help me! [message #371360] |
Fri, 06 October 2000 10:13 |
ChangHyun Bang
Messages: 5 Registered: October 2000
|
Junior Member |
|
|
I can't create trigger.
I run SQL owner is "sys" user.
CREATE TRIGGER "SYS"."LOGIN_ACC" INSTEAD OF INSERT
ON "DBA_AUDIT_SESSION"
BEGIN
INSERT INTO login_info (username, accountname, login_date)
VALUES ('oracle','kmn-id', TRUNC(SYSDATE));
END;
CREATE TRIGGER "SYS"."LOGIN_ACC" INSTEAD OF INSERT ON "DBA_AUDIT_SESSION" BEGIN
*
ERROR at line 1:
ORA-04089: cannot create triggers on objects owned by SYS
- winchild -
|
|
|
|
|
|
Re: Trigger to TABLE, but can't create. [message #371364 is a reply to message #371360] |
Fri, 06 October 2000 11:33 |
ChangHyun Bang
Messages: 5 Registered: October 2000
|
Junior Member |
|
|
CREATE OR REPLACE TRIGGER login_acc
AFTER INSERT ON aud$
BEGIN
INSERT INTO login_info (username, accountname, login_date)
VALUES ('oracle','kmn-id', TRUNC(SYSDATE));
END;
CREATE OR REPLACE TRIGGER login_acc
*
ERROR at line 1:
ORA-04089: cannot create triggers on objects owned by SYS
Why can't trigger on sys object?
Thank's
- winchild -
|
|
|
Goto Forum:
Current Time: Fri Jan 10 05:49:07 CST 2025
|