[dbo].[jmo

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

Property

Value

ANSI Nulls On

Quoted Identifier On

Created

11:10:09 AM Wednesday, March 07, 2007

Last Modified

5:39:14 PM Monday, May 04, 2009

Name
wbr_stid
wbr_groupid
wbr_node
wbr_type
wbr_timz
wbr_dsc

Name

wbr_stid

wbr_groupid

wbr_node

wbr_type

wbr_timz

wbr_dsc

Type	Action	Owning Principal
Grant	Select	emadmin
Grant	Select	emuser
Grant	Select	jmoadmin
Grant	Select	jmouser
Grant	Select	uniadmin
Grant	Select	uniuser

Type

Action

Owning Principal

Grant

Select

emadmin

Grant

Select

emuser

Grant

Select

jmoadmin

Grant

Select

jmouser

Grant

Select

uniadmin

Grant

Select

uniuser

SQL Script

CREATE view  jmo_wbr( wbr_stid, wbr_groupid, wbr_node, wbr_type, wbr_timz, wbr_dsc ) as select s.id, g.id, s.cci_node, s.type, s.time_zone, s.descr from ( jmo_station s left join  jmo_group g on s.id = g.stationid)
GO
GRANT SELECT ON  [dbo].[jmo_wbr] TO [emadmin]
GRANT SELECT ON  [dbo].[jmo_wbr] TO [emuser]
GRANT SELECT ON  [dbo].[jmo_wbr] TO [jmoadmin]
GRANT SELECT ON  [dbo].[jmo_wbr] TO [jmouser]
GRANT SELECT ON  [dbo].[jmo_wbr] TO [uniadmin]
GRANT SELECT ON  [dbo].[jmo_wbr] TO [uniuser]
GO