SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_asset_keywords_view
AS
SELECT DISTINCT arg_keywords_view.kdkwtext,
ca_owned_resource.own_resource_uuid AS object_uuid
FROM         ca_owned_resource
        INNER JOIN ca_model_def
             ON ca_owned_resource.model_uuid = ca_model_def.model_uuid
        INNER JOIN arg_keywords_view
             ON ca_owned_resource.own_resource_uuid = arg_keywords_view.object_uuid
                OR ca_model_def.model_uuid = arg_keywords_view.object_uuid

GO
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_asset_keywords_view] TO [uapmreporting_group]
GO