Views [dbo].[apps]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created11:10:10 AM Wednesday, March 07, 2007
Last Modified7:53:15 AM Monday, November 30, 2009
Columns
Name
swname
swver
swrel
swmod
swnote
hwuuid
pubname
Permissions
TypeActionOwning Principal
GrantSelectaiadmin
GrantSelectaipublic
SQL Script
CREATE VIEW apps
        AS
        SELECT    ai_swdef_prop.swname,
            ai_swdef_prop.swver,
            ai_swdef_prop.swrel,
            ai_swdef_prop.swmod,
            ai_swdef_prop.swnote,
            ai_swdef_hwdef_rel.hwuuid,
            ai_pubdef_prop.pubname
        FROM    ai_swdef_hwdef_rel
            INNER JOIN
            ai_swdef_prop
            ON ai_swdef_hwdef_rel.swuuid = ai_swdef_prop.swuuid
            INNER JOIN
            ai_pubdef_prop
            ON ai_swdef_prop.pubuuid = ai_pubdef_prop.pubuuid
GO
GRANT SELECT ON  [dbo].[apps] TO [aiadmin]
GRANT SELECT ON  [dbo].[apps] TO [aipublic]
GO
Uses