CREATE view usd_v_group_jobs_s
(    uri, user_uuid,
    group_name, agent_name, agent_type, agent_uuid,
    productname, productversion,
    object_uuid, task, state,
    errorcause, errorparam,
    activationtime,
    creationtime, completiontime,
    userparams, packagetype,
    jobname, "procedure", procedureversion)


as
select     uri, user_uuid,
    group_name, agent_name, agent_type, agent_uuid,
    productname, productversion,
    object_uuid, task, state,
    errorcause, errorparam,
    activationtime,
    creationtime, completiontime,
    userparams, packagetype,
    jobname, "procedure", procedureversion

from     usd_v_user_dhw_sec, usd_v_group_jobs

where    usd_v_user_dhw_sec.dhw_uuid
        = usd_v_group_jobs.agent_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_group_jobs_s] TO [ams_group]
GRANT REFERENCES ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group]
GRANT INSERT ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group]
GRANT DELETE ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group]
GRANT UPDATE ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_group_jobs_s] TO [ca_itrm_group_ams]
GRANT SELECT ON  [dbo].[usd_v_group_jobs_s] TO [upmuser_group]
GO