PL/SQL (MOSC)

MOSC Banner

How can I make sure a procedure can only be called from an "after logon on database" trigger?

edited Aug 3, 2023 5:12PM in PL/SQL (MOSC) 11 commentsAnswered ✓

Oracle Enterprise 19c

I have an "after logon on database" trigger (aka LOGON_TRIGGER), that I want to use to call a procedure (aka, SET_FGAC_FOR_USER), to set database session variables to be used by RLS security, but I don't want the SET_FGAC_FOR_USER procedure to be called outside the logon trigger.

I tried to mark SET_FGAC_FOR_USER as ACCESSIBLE BY LOGON_TRIGGER, but it appears it's not possible to have a procedure whitelisted to a logon trigger. I read something about "Since database logon triggers execute at the session level, they cannot directly control access to specific procedures or functions", but I didn't actually find anything in the documentation.

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