CREATE  view ca_v_jobcfg_user
as
select u.user_uuid u_user_uuid,
    u.label u_label,
    u.user_name u_user_name,
    u.domain_uuid u_domain_uuid,
    u.creation_user u_creation_user,
    u.creation_date u_creation_date,
    u.last_update_date u_last_update_date,
    u.last_update_user u_last_update_user,
    u.uri u_uri,
    u.user_type u_user_type,
    u.usage_list u_usage_list,
    u.directory_url u_directory_url,
    j.domainid j_domainid,
    j.jobid j_jobid,
    j.joname j_joname,
    j.jotype j_jotype,
    j.jocont j_jocont,
    j.jocmd j_jocmd,
    j.joos j_joos,
    j.jocreate j_jocreate,
    j.jomodify j_jomodify,
    j.josdate j_josdate,
    j.jostime j_jostime,
    j.joedate j_joedate,
    j.joetime j_joetime,
    j.jofreq j_jofreq,
    j.josched j_josched,
    j.joinst j_joinst,
    j.joonceat j_joonceat,
    j.jooncenr j_jooncenr,
    j.joflag j_joflag,
    j.joexit j_joexit,
    j.jddomid j_jddomid,
    j.jodepend j_jodepend,
    j.joquest j_joquest,
    j.joqforce j_joqforce,
    j.joqfdate j_joqfdate,
    j.jologoff j_jologoff,
    j.joremove j_joremove,
    j.jodepfil j_jodepfil,
    j.jodevice j_jodevice,
    j.joserv j_joserv,
    j.jodiscon j_jodiscon,
    j.joiconid j_joiconid,
    j.jopartnr j_jopartnr,
    j.revnr j_revnr,
    j.checksum j_checksum,
    j.job_uuid j_job_uuid,
    j.job_category j_job_category,
    j.creation_user j_creation_user,
    j.creation_date j_creation_date,
    j.last_update_user j_last_update_user,
    j.last_update_date j_last_update_date
from ca_discovered_user u, ncjobcfg j
where   UPPER(j.creation_user) collate database_default = UPPER(u.user_name) collate database_default
GO
GRANT SELECT ON  [dbo].[ca_v_jobcfg_user] TO [ams_group]
GRANT SELECT ON  [dbo].[ca_v_jobcfg_user] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_v_jobcfg_user] TO [ca_itrm_group_ams]
GO