Here is an example of database logon trigger for blocking specific users from accessing database through tools like Toad or SQL Developer tools, etc.
Subscribe to get access
Read more of this content when you subscribe today.
Any database users with “ADMINISTER DATABASE TRIGGER” will bypass the database logon trigger.
SQL> grant ADMINISTER DATABASE TRIGGER to testuser; Grant succeeded. SQL> connect testuser Enter password: Connected.