Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  What is the SQL audit hierarchy

Author  Topic  ScotHeed Starting Member 1 Post Posted - 2012-07-25 : 01:46:14 I have had to setup an audit spec on a SQL Server 2008 R2 database to capture execute, insert, update, delete based on the database with the dbo as principle. I have no issues with the setup of auditing. This is returning an expected large amount of data. What is not clear is how to determine the hierarchy in the output. I need to isolate which is the parent object as the dbo is showing everything within sp's and functions etc. I was wondering if the 'session id' could be used in conjunction with something else. All sequence no's are 1. The overall aim is to remove the db access that utilises the dbo and create a role instead. Clearly I want to only assign permissions to the objects that are actually required. Does anyone know how to determine the parent object in the audit log? Thanks folks.