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_user		varchar(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