Views [dbo].[apps]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:06 PM Sunday, December 05, 2010
Last Modified12:42:10 PM Sunday, December 05, 2010
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