InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 13:17:19 GMT20http://www.sqlservercentral.com/Forums/Topic142473-5-1.aspx<P>Try this script it will tell you not only what the users have permissions on but what user defined roles they may be getting it thru.</P><P><A href="http://www.sqlservercentral.com/scripts/contributions/268.asp">http://www.sqlservercentral.com/scripts/contributions/268.asp</A></P><P>It doesn't give system roles but you can get that from one of the SQL built in SPs. </P>Wed, 20 Oct 2004 06:16:00 GMTAntares686http://www.sqlservercentral.com/Forums/Topic142473-5-1.aspx<P>Run a query that will use sp_MSforeachDB stored procedure that will execute SQL statement for each database. The statement that you want to execute will be 'Select * from syspermissions' I was oK running this on master, but my workstation's memory was not enough when I tried to select &amp;* from syspermissions on the production database. Moreover, I would recommend to join syspermissions with sysusers and sysobjects because there are only id numbers in syspermissions and auditors would like to see real names. Otherwise the syntax is:</P><P>EXEC sp_MSforeachdb 'select * from syspermission'</P>Tue, 19 Oct 2004 15:05:00 GMTYelena Varshalhttp://www.sqlservercentral.com/Forums/Topic142473-5-1.aspx<P>What I need is a report or spreadsheet that I can hand over to auditors that shows every permission that every user has on every object in every database.</P><P>Does anyone have a comprehensive script/report that would meet these objectives...</P><P>I have several servers with many databases on each one, so to keep doing this by cut and paste is a real pain...</P><P>Even if there was a third party product that would generate such a report, that would work, I just haven't found one.</P>Tue, 19 Oct 2004 14:41:00 GMTGonzo