SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
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 Previous Topic Topic Next Topic  

rohaandba
Starting Member

33 Posts

Posted - 10/11/2012 :  16:54:22  Show Profile  Reply with Quote
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
1646 Posts

Posted - 10/17/2012 :  19:48:31  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000