/************************************************************************
    view     usd_v_container_jobs
    displays the (failed and non-installation) jobs
    of a container.

    view     usd_v_container_jobs_s
    is the security form.
************************************************************************/



/************************************************************************
    view

************************************************************************/


CREATE view usd_v_container_jobs_a_s
(    uri, user_uuid,
    containername, containercomment,
    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,
    containername, containercomment,
    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_area_sec, usd_v_container_jobs

where    usd_v_user_dhw_area_sec.dhw_uuid
        = usd_v_container_jobs.agent_uuid
GO
GRANT SELECT ON  [dbo].[usd_v_container_jobs_a_s] TO [ams_group]
GRANT SELECT ON  [dbo].[usd_v_container_jobs_a_s] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[usd_v_container_jobs_a_s] TO [ca_itrm_group_ams]
GO