• Something like this:

    SELECT 'USE ' + name + ' EXEC sp_addrolemember ''db_datareader'', ''myusername'''

    FROM master..sysdatabases

    That will generate the SQL to add the user to the role in each database. This assumes that the login is mapped to the same user name in each database.

    John