Home > IT Answers > SQL Server > Utility to Compare Security Configuration Bet...
Help

Question

  Asked: May 15 2008   8:46 PM GMT
  Asked by: Aiguy

Utility to Compare Security Configuration Between Database


SQL Server, Security, Certificates, impersonation, SQL Server 2005

We are trying to restore a SQL Server 2005 database from a production to a QA environment.

We are using certificate security, multiple schemas and certificate signed stored procedures. We need to find a utility which can tell us security configuration differences between the two environments. Any ideas?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
Last Answered: May 15 2008  9:30 PM GMT  by Mrdenny




You can give Change Directory for SQL Server (by Quest Software) a try. I'm not sure how indepth it goes with the certificates.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on SQL Server and Security.

Looking for relevant SQL Server Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register