Privileges on creating database logon trigger
420445Aug 15 2005 — edited Aug 15 2005Hi,
I am trying to create a trigger which will fire on after Logon to database. My schema is granted with the privileges to create trigger. But i am not not getting why i am receiving error
ERROR at line 1:
ORA-01031: insufficient privileges
even though i have the privileges. I can create the trigger based upon the tables while any DML cause. But why i am not possible to create trigger on databse.
Is there any other privilege for doing so???????
Trigger Code
---------------------
CREATE OR REPLACE TRIGGER SET_NLS_LOGON_TRG AFTER LOGON ON DATABASE
BEGIN
EXECUTE IMMEDIATE 'ALTER SESSION SET NLS_DATE_FORMAT = 'DD-MON-YY HH24:mi:ss' ';
END;
/
ERROR at line 1:
ORA-01031: insufficient privileges
Thanks!!!!!