October 11, 2012 at 2:53 pm
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
October 11, 2012 at 11:38 pm
rohaandba (10/11/2012)
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
HOw have you restricted the user to do DB changes ?
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
October 12, 2012 at 12:23 am
rohaandba (10/11/2012)
HI,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
erm....
By changing the code in the trigger ?
Your trigger has restricted the operation, right ?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply