Sure you can, but you have a little work to do.

This query lists users per database :

sp_MSForeachdb '

USE ?

select

db_name() as dbname

, sp.name as login

, dp.name as

from sys.database_principals dp

inner join sys.server_principals sp on sp.principal_id = dp.principal_id

WHERE dp.type_desc = ''SQL_USER''

'

Run it on your test and prod server and then :

- compare with Excel for eample

- import your prod users to your dev server (you will have to store the results in a table and then use Import Data wizard in Management Studio)

and compare with a FULL JOIN