SQL Server Forums - DDL Tracking

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

General SQL Server Forums

New to SQL Server Administration

DDL Tracking

New Topic

Reply to Topic

Printer Friendly

Author

Topic

rohaandba
Starting Member

33 Posts

Posted - 10/11/2012 : 16:54:22

HI,

One of my SQL Server Databases, I have enabled DDL Trigger to track all the DDL changes
This trigger emails me if some one with Sys-Admin permissions make any DDL changes and completely restricts othere to make any DDL change.(Though with Db Owner or DDL-Admin permission)
This trigger also writes into a DDL-table I created with the modifications done.

As mentioned this Trigger doen't not allow developers with DDL-Admin permissions and Db Owner permissions to make any DDL changes to the Databases

Is there any way I can allow the devlopers to make the DDL changes as well as I track the DDL chages.
(Any Trigger or any advice)

Thanking You

Bustaz Kool
Flowing Fount of Yak Knowledge

USA
1429 Posts

Posted - 10/17/2012 : 19:48:31

We have something similar to what you have described. The difference is that the trigger has a list of logins that are allowed to make DDL changes and compares the current login against that list before allowing the change to complete. You could hard code this list of names, select them out of a table or use a special Role whose members are allowed the make changes. There are pluses and minuses to each approach.

=================================================
We are far more concerned about the desecration of the flag than we are about the desecration of our land. -Wendell Berry

Edited by - Bustaz Kool on 10/17/2012 19:50:49

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.09 seconds.