CREATE view usd_v_common_grp as
select G.group_uuid as objectid, G.version_number+1 as version,
G.creation_user as creation_user, G.evaluation_uuid as qtask,
0x00000000000000000000000000000000 as aux, 0x00000000000000000000000000000000 as aux2,
7 as type, 0x00000000 as attributes, G.label as name, G.description as comment,
G.creation_date as credate, G.creation_date as cretime, G.last_update_date as chdate,
G.last_update_date as chtime, 0 as propflag, '' as qcalendar, G.eval_freq as qevalrate,
0 as qnextevaldate, 0 as qnextevaltime, G.last_eval_date_time as qevaldate,
G.last_eval_date_time as qevaltime, 0x00000000000000000000000000000000 as qtemplfold,
0 as qtype, 0 as state, 0 as seal, 0 as var, '' as auxtext0, '' as auxtext1, '' as auxtext2,
'' as auxtext3, G.query_uuid as queryid, G.evaluation_location as evaluation_location,
G.group_flag as group_flag, G.group_system as group_system, G.group_uuid, G.member_type
from ca_group_def G
GO
GRANT SELECT ON  [dbo].[usd_v_common_grp] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_common_grp] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_common_grp] TO [ca_itrm_group_ams]
GO