Audti Trial for a single user

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Sarbanes-Oxley » Audti Trial for a single user

Audti Trial for a single user

Rate Topic

Display Mode

Topic Options

Author

Message

WAGalaxy

Posted Monday, August 24, 2009 9:44 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, September 07, 2012 7:13 PM
Points: 10, Visits: 80

Hello

For business requirements I want to create another sysadmin account called "sa2" and give it to the Software Developers/Business Analysts to use so they can perform their duties. What I want to do is implement a audit trail for that user only to capture any update/delete as well as creating databases, indexes, fields etc...pretty much everything for that user. We use SQL 2005 and 2008.

Have anyone done this before? Your help/advice is muchly appreciated.

Thanks
Brandon

Post #776423

Lynn Pettis

Posted Monday, August 24, 2009 10:25 PM

SSC-Insane

Group: General Forum Members
Last Login: Yesterday @ 11:14 PM
Points: 21,832, Visits: 27,862

Please do not make multiple post for the same request. It simply fragments and potentially duplicates answers you may receive. Please post any replies here.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #776432

« Prev Topic | Next Topic »

Permissions