Views [dbo].[csm_v_property]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:07 PM Sunday, December 05, 2010
Last Modified12:40:39 PM Sunday, December 05, 2010
Columns
Name
TYPE
I_VALUE
ID
NAME
OBJECT
VALUE
Permissions
TypeActionOwning Principal
GrantSelectams_group
GrantSelectca_itrm_group
GrantSelectca_itrm_group_ams
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