Prevent applications to log in on Oracle Database

Question

Does anybody knows how could I make a trigger or anything else to prevent people to connect on my database with any kind of applications besides mine?

Note that the super-old-and-unsecure trigger to block few .exe such TOAD or watever does NOT really works, since you can just rename the EXE to MyApplication.exe.

Hints?

Answer 1

An easier method would be to move the security to a role that can be enabled only by your application - see a previous answer of mine here

WIth this method another application may create a session but has no other privileges since the role is not enabled.