SQLServerCentral.com Articles tagged DDL Triggers

Blocking Users by IP

Fri, 15 Apr 2011 06:00:00 UT

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

Tue, 17 Aug 2010 06:00:00 UT

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.

Granting limited permissions to create views in another schema in SQL Server - Part 2

Mon, 17 Aug 2009 06:00:00 UT

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

Creating a recycle bin for SQL Server 2005\2008

Wed, 20 May 2009 06:00:00 UT

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.

New! Safeguard your SQL backups
Protect your backups from onsite disaster with SQL Backup Pro and a Hosted Storage account from Red Gate. Learn more

Blocking Users by IP

Fri, 15 Apr 2011 06:00:00 UT

Securing SQL with access control and login monitoring

Mon, 16 Feb 2009 07:00:00 UT

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.

Monitoring Changes in Your Database Using DDL Triggers

Thu, 02 Oct 2008 06:00:00 UT

Auditing and monitoring activity in your databases is becoming more and more important all the time. New author David Dye brings us a short introduction to using DDL triggers to help.

Top 5 hard-earned Lessons of a DBA
New! Part 4, ‘Disturbing Development’ by Grant Fritchey, features the return of Joe Deebeeay and a server-threatening encounter with ORMs - read it here

Using DDL triggers to audit events

Thu, 15 May 2008 06:00:00 UT

Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.