CREATE    VIEW dbo.appsbycategory
        AS
        SELECT    dbo.ai_swdef_prop.*,
            dbo.ai_swcat_prop.scname AS scname,
            dbo.ai_swcat_prop.scnote AS scnote
        FROM    dbo.ai_swdef_prop
            INNER JOIN
            dbo.ai_swcat_swdef_rel
            ON dbo.ai_swdef_prop.swuuid = dbo.ai_swcat_swdef_rel.swuuid
            INNER JOIN
            dbo.ai_swcat_prop
            ON dbo.ai_swcat_swdef_rel.scuuid = dbo.ai_swcat_prop.scuuid
        
GO
GRANT SELECT ON  [dbo].[appsbycategory] TO [aiadmin]
GRANT INSERT ON  [dbo].[appsbycategory] TO [aiadmin]
GRANT DELETE ON  [dbo].[appsbycategory] TO [aiadmin]
GRANT UPDATE ON  [dbo].[appsbycategory] TO [aiadmin]
GRANT SELECT ON  [dbo].[appsbycategory] TO [aipublic]
GO