PL/SQL (MOSC)

MOSC Banner

Logon Trigger - Insufficients privileges

in PL/SQL (MOSC) 4 commentsAnswered ✓

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''');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center