Logon Trigger - Insufficients privileges
Oracle 19C
I'm trying to create a logon trigger for a user, so that when he logs into the database, he must change the nls_date_format parameter in his session. I have already granted several privileges: connect, create session, alter session, create trigger, create any trigger and administer database trigger.
However, when I run the command to create the trigger, it gives the message of insufficient privileges.
The command I'm running is the following:
create or replace TRIGGER TG_POS_LOGON
AFTER LOGON ON database
BEGIN
if (user = 'XXXXXX') then
dbms_session.set_nls('NLS_DATE_FORMAT','''DD/MM/YYYY''');