[dbo].[UserGroupView]

(local) > mdb > Views > dbo.UserGroupView

Properties
Columns
Permissions
SQL Script
Uses
Used By

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:04 AM Wednesday, March 07, 2007
Last Modified	5:37:38 PM Monday, May 04, 2009

Columns

Name
userId
grpId
server_addr
probe_addr
rsrcIndex
rsrcOtherIndex
grpType
grpName

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin

SQL Script

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

Uses

[dbo].[groupaccesslist]
[dbo].[network_groupid]
[dbo].[network_groups]
dbo

Used By

[dbo].[UserGroupResourceView]