Server User Access

CREATE PROCEDURE usp_get_users 
AS
declare @db_name sysname
declare @db_filename nvarchar(128)
declare @SQL nvarchar(600)

-- Create temporary table to 
-- store database information
create table 
#shawndatabsesusers(
db_uservarchar(30),
dbase_name sysname NOT NULL,
)
declare c1 cursor for
SELECT name, filename FROM master.dbo.sysdatabases ORDER BY name

open c1
fetch next from c1 into @db_name, @db_filename

while @@fetch_status >= 0
begin
SELECT @SQL = 'INSERT INTO #shawndatabsesusers
SELECT name, ''' +  @db_name + ''' FROM ' + @db_name + '..sysusers where islogin = 1'
-- PRINT @SQL
-- execut @SQL to insert row for each database
 execute (@SQL)
fetch next from c1 into @db_name, @db_filename
end
deallocate c1

SELECT * FROM #shawndatabsesusers