Skip to content

Make DBA Life Easy

  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy

Tag: RAISE_APPLICATION_ERROR(-20001

Schema Logon Trigger to Block Logon Sessions from Toad, SQL Developer, Sqlplus….

In production environment, sessions from developers using tools like Toad, SQL Developer, Sqlplus, etc can be blocked by after schema logon trigger.

Subscribe to get access

Read more of this content when you subscribe today.

SubscribeSubmitting form
Log in
Unknown's avatarAuthor dbalifeeasyPosted on August 29, 2019October 19, 2020Categories Premium Content, Security, SQL Scripts For DBATags ..., Block Logon Sessions from SQL Developer, Block Logon Sessions from Toad, Block Logon Sessions Sqlplus, Logon Trigger, RAISE_APPLICATION_ERROR(-20001, Schema Logon Trigger, sys.v_$mystat, sys.v_$sessionLeave a comment on Schema Logon Trigger to Block Logon Sessions from Toad, SQL Developer, Sqlplus….

Google Translate

SEARCH

Calendar

December 2025
M T W T F S S
1234567
891011121314
15161718192021
22232425262728
293031  
« Nov    

Archives

Blog Stats

  • 1,435,528 hits

Categories

  • AWS (9)
  • GoldenGate (13)
    • Config (2)
    • Docs (1)
    • Exam & Interview Q/A (1)
    • How To (1)
    • Install and Upgrade (2)
    • JAgent (1)
    • OGG ERROR (4)
    • OGGMON (1)
  • Linux (29)
  • MySQL (4)
    • Install and Upgrade (3)
    • Startup and Shutdown (1)
  • Oracle (638)
    • 12c/13c/18c/19c/20x New Features (9)
    • ADR (2)
    • ASM (34)
    • Audit (4)
    • AWR (5)
    • BI Report (3)
    • CDB/PDB (27)
    • CHM (14)
    • Client (14)
    • CMU (2)
    • Configuration (31)
    • Corruptions (3)
    • DataGuard (60)
    • DataPump (17)
    • dbms_scheduler (6)
    • Exadata & ExaCC (10)
    • FLASHBACK (5)
    • GI and RAC (127)
    • Globalization (1)
    • Install Upgrade and Patches (70)
    • JAVA (2)
    • Materialized View (7)
    • OCI (5)
      • ADW / ATP (3)
      • Object Storage (1)
      • Veridata (1)
    • OEM( Oracle Enterprise Manager) (94)
      • OEM 12c (9)
      • OEM13c (87)
    • ORA- ERRORS (65)
    • oracle advanced compression (4)
    • ORMB (13)
    • Partitioning (12)
    • Performance Tunning (28)
    • RMAN Restore and Recovery (30)
    • Security (13)
    • Services (2)
    • SQL Net (16)
    • SQL Scripts For DBA (27)
    • Statistics (1)
    • TDE (7)
    • TOOLS( AHF TFA ORAchk EXAchk ) (6)
    • TTS (1)
    • Upgrade (2)
    • User Privileges and Roles (19)
    • Weblogic (1)
  • PostgreSQL (31)
    • Client (4)
    • Extension (6)
    • Install and Upgrade (8)
    • Migration (4)
    • Objects (4)
    • Performance Tuning (1)
    • Privileges (1)
    • SQL Scripts for DBA (4)
    • Vacuum (4)
  • Premium Content (231)
  • SQL Server (27)
    • Always On (3)
    • Backup and Restore (2)
    • Client (1)
    • Install Patch and Upgrade (4)
    • Security (3)
    • Space (2)
    • SQL Scripts for DBA (6)
    • SSMA (4)
    • Versions (2)
  • VirtualBox (14)
  • Windows (15)

Meta

  • Create account
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy Blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Subscribe Subscribed
    • Make DBA Life Easy
    • Join 58 other subscribers
    • Already have a WordPress.com account? Log in now.
    • Make DBA Life Easy
    • Subscribe Subscribed
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar