Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Create Triggers on System Tables

Hi,

I want to call a certain procedure that logs everytime a database user is created or deleted in the db ( sql Anywhere 16).

For this I have written a Function that should be called via a trigger when a row is inserted or deleted from table SYS.SYSUSER.

However, I am not able to create a trigger on this table.

Am I allowed to create trigger on this or is there someother way to get notified whenever a user is created or deleted for db?

New to sybase please help.

heres is my create trigger code

    CREATE TRIGGER myTrigger AFTER INSERT ON sys.sysuser

    REFERENCING NEW AS newRecord

    FOR EACH ROW

    BEGIN

          -- call myFunction

    END;

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question