and

select *, object_name(major_id) from sys.database_permissions where grantor_principal_id = user_id ('the_user')

returned NULL for object_name(major_id)

thanks, but the user in question was not returned as an owner

I should also mention that the user is an orphan (that is, there is no associated login) - not...

whoops, I meant

object_name(id) is NULL

ok, I did

select user_name(grantor), object_name(id), *

from sysprotects (nolock)

where grantor = USER_ID ( 'the_user' )

but object_id(id) is null

any ideas on the next move?

thanks

just found it... it's in sys.sql_logins

this script has it (along with a bunch of other stuff): http://www.sqlservercentral.com/scripts/31776/

thanks

W