List all database users created for one login user

Question

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 1

You'd have to check each database (sysusers) and join back to syslogins.

ms_foreachdb will help you.

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 2

create table #temp

(

dbname varchar(16),

username varchar(30)

)

insert into #temp

exec sp_MSforeachdb 'Select ''?'' as DB_Name, su.name from ?.dbo.sysusers su

join master.dbo.syslogins sl on sl.sid=su.sid

and sl.name=''Enter Login Name Here'''

select * from #temp

MJ