/* End of lines added to convert to online lock */


CREATE view ca_v_query_def_user
as
select
    q.domain_uuid as q_domain_uuid,
    q.query_uuid as query_uuid,
    q.label as q_label,
    q.query_type as query_type,
    q.query_cont as query_cont,
    q.target_table as q_target_table,
    q.target_type as q_target_type,
    q.creation_user as q_creation_user,
    q.creation_date as q_creation_date,
    q.last_update_user as q_last_update_user,
    q.last_update_date as q_last_update_date,
--    q.version_number as q_version_number,
--    q.auto_rep_version as q_autorep_version,
    u.user_uuid as user_uuid,
    u.label        as u_label,
    u.user_name     as user_name,
    u.domain_uuid    as u_domain_uuid,
    u.creation_user as u_creation_user,
    u.creation_date as u_creation_date,
    u.last_update_user as u_last_update_user,
    u.last_update_date as u_last_update_date,
--    u.version_number as u_version_number
--    u.auto_rep_version as u_autorep_version
    u.uri    as u_uri,
    u.user_type as user_type,
    u.usage_list    as u_usage_list,
    u.directory_url as u_directory_url


from ca_query_def q, ca_discovered_user u
where  u.uri  collate database_default = q.creation_user collate database_default
    and u.uri is not null
    and q.creation_user is not null
    and q.domain_uuid = u.domain_uuid
GO
GRANT SELECT ON  [dbo].[ca_v_query_def_user] TO [ams_group]
GRANT SELECT ON  [dbo].[ca_v_query_def_user] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[ca_v_query_def_user] TO [ca_itrm_group_ams]
GO