List All DBs To Which A User Has Access
Posted on 2003-10-30
I know I can run sp_helplogins and get all the databases for which a user has access but we're building a custom security application that will need to add and drop user's logins.
Before I go and tear sp_helplogins apart and rebuild it to only return the second set of records I wanted to see if anyone else had already cracked this nut.
Basicall I need a SQL query that will return all the databases to which a given login name has access. I could do this as a stored procedure call if someone has that.
Until I hear back, I'll keep looking at writing my own version of "sp_helplogins lite."