[dbo].[csm_v_property]

(local) > mdb > Views > dbo.csm_v_property

Properties
Columns
Permissions
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On
Created	11:10:10 AM Wednesday, March 07, 2007
Last Modified	6:12:20 PM Monday, May 04, 2009

Columns

Name
TYPE
I_VALUE
ID
NAME
OBJECT
VALUE

Permissions

Type	Action	Owning Principal
Grant	Select	ca_itrm_group
Grant	Select	ca_itrm_group_ams
Grant	Select	ams_group

SQL Script

CREATE VIEW CSM_V_PROPERTY (TYPE, I_VALUE, ID, NAME, OBJECT, VALUE) AS
  select dbo.fn_get_cms_property(0,value) type,
        dbo.fn_get_cms_property(1,value) I_VALUE,
        id,
        name,
        object,
        value /* as in csm_property */
    from csm_property
GO
GRANT SELECT ON  [dbo].[csm_v_property] TO [ams_group]
GRANT SELECT ON  [dbo].[csm_v_property] TO [ca_itrm_group]
GRANT SELECT ON  [dbo].[csm_v_property] TO [ca_itrm_group_ams]
GO

Uses

[dbo].[csm_property]
[dbo].[fn_get_cms_property]
dbo