CREATE VIEW CSM_V_PROPERTY (TYPE, I_VALUE, ID, NAME, OBJECT, VALUE) AS
  select dbo.fn_get_cms_property(0,value) type,
        dbo.fn_get_cms_property(1,value) I_VALUE,
        id,
        name,
        object,
        value /* as in csm_property */
    from csm_property
GO
GRANT SELECT ON  [dbo].[csm_v_property] TO [ams_group]
GRANT SELECT ON  [dbo].[csm_v_property] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[csm_v_property] TO [ca_itrm_group_ams]
GO