How To Determine Which Objects User Owns 1

[JohnBates]

Hi,

If user abc has created some objects, how can I determine those object names? I know there's a system stored proc, but I cant find it.

thanks, john

 

[JohnBates]

..have I stumped everyone ?

 

[MDXer]

I don't know the procedure your talking about but you this will give you a list of objects within a DB that a user owns.

select 
u.Name as 'User',
o.Name as 'Object 
from sysobjects o
	JOIN sysusers u ON u.uid = o.uid
where u.Name = 'dbo'

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[MikeWiz9]

Add to the where clause, AND o.xtype = 'u'
So it should look like this...

SELECT u.Name as "User", o.Name as "Object "
FROM sysobjects o
JOIN sysusers u ON u.uid = o.uid
WHERE u.Name = 'dbo'
AND o.xtype = 'u'

 

[JohnBates]

wow MDXer,

That's exactly what I needed. Maybe there is not a sys sp. I never found one that does this.

thanks, John