We need the complete list of permission/securable of all users for all our databases and server.
Via 'Microsoft SQL Server Management Studio' I've looked manually, by right clicking on the database and write down via 'Permissions' Tab the permissions of all databases.
Sadly these are not all permissions, for example tables/views securables are not listed.
Is there a way to export ALL permissions into Excel/Visio 2007? (It doesn't have to be all at once.)