Reply To: Report Builder : SQL join Limitations

#6493
Israr Ahmed
Keymaster

and another one :

CREATE VIEW dbo.USER_view_idxdef_gptdef as (

SELECT
idx.index_id , idx.index_version_id , gpt.gpt_id , idx.db_status
FROM
idx_def idx , idx_gpt_def gpt
WHERE
(idx.index_version_id = gpt.index_version_id) AND ( idx.db_status = 1 )

)

grant select on dbo.USER_view_idxdef_gptdef to olf_user
grant select on dbo.USER_view_idxdef_gptdef to olf_readonly

Download PDF version

This field is for validation purposes and should be left unchanged.