Hi,
I am not very experienced in t-sql. Recently working on SSIS projects, and found SSISDB Catalog related views, all ended with similar syntax as below. Not sure what "0=1" means, did some research, not luck. Ended guessing everyone would have permission for this view...
Can anyone help me out? Thanks,
ALTER VIEW [catalog].[environment_references]
AS
SELECT .......
WHERE [project_id] in (SELECT [id] FROM [internal].[current_user_readable_projects])
OR (IS_MEMBER('ssis_admin') = 1)
OR (IS_SRVROLEMEMBER('sysadmin') = 1)
OR (0 = 1)