CREATE VIEW UserGroupView AS
select gac.userId
    , g.grpId
    , g.server_addr
    , g.probe_addr
    , g.rsrcIndex
    , g.rsrcOtherIndex
    , gid.grpType
    , gid.grpName
from GroupAccessList gac, network_Groups g, network_GroupId gid
where gac.grpId = g.grpId
    AND gid.grpId = g.grpId
GO
GRANT SELECT ON  [dbo].[UserGroupView] TO [uniadmin]
GO