create view  iam_attribute_view ( object_guid, attribute_name, attribute_value, attribute_shortvalue, attribute_order ) as select s1.norm object_guid, a2.description attribute_name, ss.norm attribute_value, s2.norm attribute_shortvalue, s2.vid attribute_order from ( search s1 inner join  attr a1 on s1.aid = a1.aid and a1.description = 'pozId') inner join ( search s2 inner join  attr a2 on s2.aid = a2.aid and a2.objectid like '2.1104.%') on s1.eid = s2.eid left join  subsearch ss on ss.eid = s1.eid and ss.aid = s1.aid and ss.vid = s1.vid and ss.cid = 1


GO
GRANT SELECT ON  [dbo].[iam_attribute_view] TO [dsaadmin]
GO