this is for MS SQL-Server (you did not specify the database used)
here is the original source of the answer
DECLARE @vCommand nvarchar(4000)
DECLARE @tResult TABLE (DBName varchar(255), UserName varchar(255))
SELECT @vCommand = 'use [?]
SELECT ''?'' AS DBName,
[name] AS username
FROM sys.sysusers
WHERE islogin = 1
AND hasdbaccess = 1'
INSERT INTO @tResult
EXEC sp_MSforeachdb @vCommand
SELECT * FROM @tResult t
WHERE t.UserName = 'user_1'
AND t.DBName like '%PRD%'