Hi all,

We have a problem when trying to restrict access to the database for the
users. The requirements from management is that users should only be
allowed access via our applications and not via query tools etc.

We tried to implement this with a logon-trigger which allowed only
specific applications based on v$session.program.

This seems to work ok in most cases but we have stumbled upon some
obstacles. Some users get no value at all in v$session.program and some
users get the full path to the application.

What might be the reason for this behaviour?

Best regards,
Joakim

Oracle LazyDBA home page