I use this script to find which object the user have:

select 'select * from ['+s.name+'].['+o.name+'] where ['+c.name +']=User_ID(''LoginName'')'

FROM sys.all_columns c

JOIN sys.all_objects o ON o.object_id = c.object_id

join sys.schemas s ON o.schema_id = s.schema_id

WHERE c.name LIKE '%principal_id%'

and o.name not like 'fn_%'