[dbo].[processlistview]

(local) > mdb > Views > dbo.processlistview

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:29 AM Wednesday, March 07, 2007
Last Modified	11:10:29 AM Wednesday, March 07, 2007

Columns

Name
processid
processname

Permissions

Type	Action	Owning Principal
Grant	Select	aionadmin_group

SQL Script

CREATE VIEW "processlistview" AS
       SELECT DISTINCT "stats"."processid", "stats"."processname"
       FROM "stats", "productidview"
       WHERE (stats.productid = productidview.productid)

GO
GRANT SELECT ON  [dbo].[processlistview] TO [aionadmin_group]
GO

Uses

[dbo].[stats]
[dbo].[productidview]
dbo