유저가 권한을 가진 오브젝트 보기

select	b.name as cObjectName
	,	c.name as cAccount
	,	schema_name(b.[schema_id]) as cSchema
	,	b.[type] as cObjectType
from	sys.database_permissions as a
		inner join
		sys.all_objects as b
	on	b.[object_id] = a.major_id
		inner join
		sys.database_principals as c
	on	c.principal_id = a.grantee_principal_id
where	a.class = 1
	and	c.name = N'test'
go