question

I've interpreted your question to mean that you want the 'XXX' account to have the ability to read any data in a user database on the server. Add the user using Enterprise Manager or sp_addlogin, then add them to the db_datareader role on the databases you want to add them to (you will need to make them a user in each of those databases). You could use sp_MSforeachdb to do this for all databases, depending on the number of databases on the server. Obviously you will want to review the implications of the role in Books Online; you may require additional access to execute stored procedures. You should also consider whether the account will be SQL or Windows Authentication.

In addition to @Dave_Green 's answer: If you want the user to have ReadOnly access, you should also add the user to the db_denydatawriter role. To do that for all user databases in an instance, using exec sp_addlogin @loginame='testuser', @passwd='Pa$$w0rd' exec sp_MSForEachDB @command1=' IF ''[?]'' not in (''master'',''model'',''msdb'',''tempdb'') BEGIN exec [?].dbo.sp_adduser @loginame=''testuser'' exec [?].dbo.sp_addrolemember ''db_datareader'',''testuser'' exec [?].dbo.sp_addrolemember ''db_denydatawriter'',''testuser'' END ' But please bear in mind that sp_MSForEachDB is undocumented and is used at your own risk.