Views [dbo].[arg_asset_keywords_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:34:39 PM Thursday, February 10, 2011
Last Modified10:34:39 PM Thursday, February 10, 2011
Columns
Name
kdkwtext
object_uuid
Permissions
TypeActionOwning Principal
GrantSelectswcmadmin
SQL Script
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]
GO
Uses