CREATE view usd_compos as
select P.proc_os_uuid as objectid, 1 as version, P.proc_os_id as id, P.proc_os_name as os,
P.msg_code_base as msgCodeBase from ca_proc_os P
GO
GRANT SELECT ON  [dbo].[usd_compos] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_compos] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_compos] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_compos] TO [upmuser_group]
GO