List of Users and Databases

Hi there,
I am wanting to get a list of databases (in sql 2000) and the users
who have access to each database. Does anyone know what SQL statement
I can use to get this information? Thanks
Richard
Try this:
Declare @.Databasename varchar(100)
Declare @.MySQLString nvarchar(100)
SET NOCOUNT ON
declare c_Databasename insensitive cursor for
select name from master..sysdatabases
open c_Databasename
fetch next from c_Databasename into @.Databasename
while @.@.fetch_status = 0
BEGIN
SET @.MySQLString = 'Select '''+@.Databasename+''' [Database],name [users]
from '+@.Databasename+'.dbo.sysusers where sid is not null'
exec sp_executesql @.MySQLString
fetch next from c_Databasename into @.Databasename
END
close c_Databasename
deallocate c_Databasename
"Richie.Cunningham" wrote:

> Hi there,
> I am wanting to get a list of databases (in sql 2000) and the users
> who have access to each database. Does anyone know what SQL statement
> I can use to get this information? Thanks
> Richard
>
|||Richie
Try something like that
SELECT *
FROM sysmembers membs
JOIN sysusers users on membs.memberuid = users.uid
JOIN sysusers groups on membs.groupuid = groups.uid
"Richie.Cunningham" <richplimmer@.yahoo.co.nz> wrote in message
news:1184017601.784136.45900@.z28g2000prd.googlegro ups.com...
> Hi there,
> I am wanting to get a list of databases (in sql 2000) and the users
> who have access to each database. Does anyone know what SQL statement
> I can use to get this information? Thanks
> Richard
>