[dbo].[userhasreports]

(local) > mdb > Views > dbo.userhasreports

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:12 PM Sunday, December 05, 2010
Last Modified	12:42:11 PM Sunday, December 05, 2010

Columns

Name
PMF
ReportsTo

Permissions

Type	Action	Owning Principal
Grant	Select	aiadmin
Grant	Select	aipublic

SQL Script

CREATE VIEW "userhasreports" ("PMF", "ReportsTo")  AS
       SELECT "ai_usrdef_prop"."samid", "ai_usrdef_prop"."mgr"
       FROM "ai_usrdef_prop"
GO
GRANT SELECT ON  [dbo].[userhasreports] TO [aiadmin]
GRANT SELECT ON  [dbo].[userhasreports] TO [aipublic]
GO

Uses

[dbo].[ai_usrdef_prop]
dbo