[dbo].[productkeyview]

(local) > mdb > Views > dbo.productkeyview

Properties
Columns
Permissions
SQL Script
Uses
Used By

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

Columns

Name
product_key

Permissions

Type	Action	Owning Principal
Grant	Select	aionadmin_group

SQL Script

CREATE VIEW "productkeyview" ("product_key")  AS
       SELECT "kpi_properties"."value"
       FROM "kpi_properties"
       WHERE name = 'pr.product_key'

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

Uses

[dbo].[kpi_properties]
dbo

Used By

[dbo].[productidview]