[dbo].[wvT1]

[dbo].[wvT1]

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	12:32:27 PM Sunday, December 05, 2010
Last Modified	7:22:06 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 wvT1 As select * from  tng_link where class_name ='T1'
GO
GRANT SELECT ON  [dbo].[wvT1] TO [uniadmin]
GRANT SELECT ON  [dbo].[wvT1] TO [uniuser]
GRANT SELECT ON  [dbo].[wvT1] TO [wvadmin]
GRANT SELECT ON  [dbo].[wvT1] TO [wvuser]
GO

Uses

[dbo].[tng_link]
dbo