Can I, on an update trigger, add a user to an Active Directory security group? Please help with the T-sql. It is beyond my skills, but the need is there! thanks.
Nov 10 '09 at 01:30 PM
Nov 11 '09 at 08:47 AM
Melvyn Harbour 1 ♦♦
One way you could do this is by running WMI scripts through XPCmdShell in your trigger.
Read more on the WMI script here:
There are multiple issues with this, though:
Nov 10 '09 at 02:44 PM
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
asked: Nov 10 '09 at 01:30 PM
Seen: 2159 times
Last Updated: Nov 11 '09 at 08:47 AM
not possible to add a group to a database role?
Has anyone tried TDE and seen how it performs in production
IS THE PORT 1433 A SECURE PORT
SQL Server Login Audit
Using views & triggers for security instead of stored procedures
Tracking record's origin
how to find dropped login by whoom
How do you get disk drive stats without the use of OLE Automation or XP_CMDSHELL?
Database Backup & Restore
Linked server connecting problem
Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.Ask SQL Server Central is a community service provided by Red Gate.