CREATE    VIEW [dbo].[allcomputerspwrmgmtlevel]
        AS
        SELECT    DISTINCT pwrmgmtlaptoplevel.hwuuid,
        pwrmgmtlaptoplevel.ZScore,
        pwrmgmtlaptoplevel.pwrmgmtlevel            
        FROM    dbo.pwrmgmtlaptoplevel
        
        UNION
        SELECT    DISTINCT pwrmgmtdesktoplevel.hwuuid,
        pwrmgmtdesktoplevel.ZScore,
        pwrmgmtdesktoplevel.pwrmgmtlevel
        FROM    pwrmgmtdesktoplevel
        
        UNION
        SELECT    DISTINCT pwrmgmtserverlevel.hwuuid,
        pwrmgmtserverlevel.ZScore,
        pwrmgmtserverlevel.pwrmgmtlevel
        FROM pwrmgmtserverlevel;
GO
GRANT SELECT ON  [dbo].[allcomputerspwrmgmtlevel] TO [aiadmin]
GRANT INSERT ON  [dbo].[allcomputerspwrmgmtlevel] TO [aiadmin]
GRANT DELETE ON  [dbo].[allcomputerspwrmgmtlevel] TO [aiadmin]
GRANT UPDATE ON  [dbo].[allcomputerspwrmgmtlevel] TO [aiadmin]
GRANT SELECT ON  [dbo].[allcomputerspwrmgmtlevel] TO [aipublic]
GO