Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I've just joined the data team of a new company and we have a large SQL Server environment (100+ instances) and cross database ownership chaining is on by what I gather is a necessity. I'm looking for 3rd party tools or even scripts for some way to audit potential access to a database including the potential of cross-database ownership chaining. Does anyone know of any way to accomplish this, or any products that do the same sort of thing?

I have mostly 2008R2 and some 2012 instances...there may be one or two 2005 machines but they can be safely ignored. EDIT: Enterprise Edition mostly as well. May be some Standard.

share|improve this question
1  
Are you just looking to find out which databases and/or instances have this set? –  Thomas Stringer Dec 7 '12 at 14:56
    
No, I don't think so; I apologize if I'm a little hazy on the overall concepts, but the idea is to ascertain, bearing in mind what instances/dbs have this enabled, who could have potential access to an object/database both directly, and as a potential access through, say, creating a stored procedure on another database using cross database ownership chaining. –  Nic Neufeld Dec 7 '12 at 18:36
    
What version(s) of SQL Server are you using? –  SQLRockstar Dec 7 '12 at 19:39
    
@SQLRockstar, [op reports] I have mostly 2008R2 and some 2012 instances...there may be 1 or 2 2005 machines but they can be safely ignored. EDIT: Enterprise Edition mostly as well. May be some Standard. –  jcolebrand Dec 7 '12 at 20:35
    
I don't know of any scripts to accomplish this, but SQL Secure from Idera mentions the ability to evaluate cross database chaining. idera.com/SQL-Server/SQL-secure –  sqlbattsman Dec 8 '12 at 14:31
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.