Skip to content

Make DBA Life Easy

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

Day: August 29, 2019

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.

Subscribe
Log in
Author 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

August 2019
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Jul   Sep »

Archives

Blog Stats

  • 1,159,086 hits

Categories

  • AWS (9)
  • GoldenGate (6)
    • Config (2)
    • Docs (1)
    • Exam & Interview Q/A (1)
    • Install and Upgrade (2)
  • Linux (26)
  • MySQL (4)
    • Install and Upgrade (3)
    • Startup and Shutdown (1)
  • Oracle (535)
    • 12c/13c/18c/19c/20x New Features (9)
    • ADR (2)
    • ASM (27)
    • AWR (5)
    • CDB/PDB (18)
    • CHM (14)
    • Client (10)
    • CMU (2)
    • Configuration (25)
    • Corruptions (3)
    • DataGuard (52)
    • DataPump (17)
    • dbms_scheduler (6)
    • Exadata & ExaCC (10)
    • FLASHBACK (2)
    • GI and RAC (109)
    • Globalization (1)
    • Install Upgrade and Patches (64)
    • JAVA (2)
    • Materialized View (7)
    • OEM( Oracle Enterprise Manager) (79)
      • OEM 12c (8)
      • OEM13c (72)
    • ORA- ERRORS (55)
    • oracle advanced compression (4)
    • ORMB (13)
    • Partitioning (12)
    • Performance Tunning (28)
    • RMAN Restore and Recovery (20)
    • Security (10)
    • SQL Net (16)
    • SQL Scripts For DBA (25)
    • TDE (6)
    • TOOLS( AHF TFA ORAchk EXAchk ) (6)
    • TTS (1)
    • User Privileges and Roles (16)
  • 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 (229)
  • SQL Server (26)
    • Always On (3)
    • Backup and Restore (2)
    • Client (1)
    • Install Patch and Upgrade (4)
    • Security (2)
    • Space (2)
    • SQL Scripts for DBA (6)
    • SSMA (4)
    • Versions (2)
  • VirtualBox (14)
  • Windows (15)

Meta

  • Register
  • Log in
  • Entries feed
  • Comments feed
  • WordPress.com
  • Home
  • Blog
  • Investment
  • About
  • Contact
  • Disclaimer
  • Subscribe
Make DBA Life Easy Blog at WordPress.com.
  • Follow Following
    • Make DBA Life Easy
    • Join 48 other followers
    • Already have a WordPress.com account? Log in now.
    • Make DBA Life Easy
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar