November 30, 2011 at 10:58 am
Does anyone have a way that they compare user permissions between two different sql servers? We have DEV and QA where a third party application is working in DEV and not QA. We think there is a permission issue between the two that is causing the issue. What query can I run in each environment to see what permissions are allowed on database level and even to the object level?
Any ideas would be helpful.
November 30, 2011 at 11:35 am
Here is one that goes down to the object level.
http://jasonbrimhall.info/2010/03/19/security-audit/
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 30, 2011 at 11:52 am
November 30, 2011 at 11:54 am
salum (11/30/2011)
http://www.sql-server-performance.com/2002/object-permission-scripts/
Nice find.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
November 30, 2011 at 12:39 pm
Great examples. Thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply