[dbo].[wvWireless]

(local) > mdb > Views > dbo.wvWireless

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:32 PM Sunday, December 05, 2010
Last Modified	7:22:12 PM Friday, January 07, 2011

Columns

Name
uuid
name
label
class_name
source_class
source_uuid
source_repository
source_port
dest_class
dest_uuid
dest_repository
dest_port
date_ins
status_no
severity
tng_delete_flag
hidden
alarmset_name
direction
source_seq
dest_seq
parent_link
implied
link_flag
reserved
unimplied
common_ancestor_class
common_ancestor_uuid

Permissions

Type	Action	Owning Principal
Grant	Select	uniadmin
Grant	Select	uniuser
Grant	Select	wvadmin
Grant	Select	wvuser

SQL Script

CREATE VIEW wvWireless As select * from  tng_link where class_name ='Wireless'
GO
GRANT SELECT ON  [dbo].[wvWireless] TO [uniadmin]
GRANT SELECT ON  [dbo].[wvWireless] TO [uniuser]
GRANT SELECT ON  [dbo].[wvWireless] TO [wvadmin]
GRANT SELECT ON  [dbo].[wvWireless] TO [wvuser]
GO

Uses

[dbo].[tng_link]
dbo