SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_class_attribute_sec_view AS SELECT arg_class_def.class_name AS class_class_name, arg_class_def.class_label, arg_class_def.class_alias, arg_class_def.class_template AS class_class_template, arg_class_def.table_name AS class_table_name, arg_attribute_def.attribute_name, arg_attribute_def.attribute_label, arg_attribute_def.attribute_alias, arg_attribute_def.relation_type, arg_attribute_def.table_name, arg_attribute_def.field_name, arg_attribute_def.attribute_type, arg_attribute_def.join_name, arg_attribute_def.class_template, arg_attribute_def.class_name, arg_class_def.control_object,arg_class_def.control_name, SECURITY_1.seattupd, SECURITY_1.serdid, arg_security.seattupd AS attr_seattupd, arg_attribute_def.control_object AS attr_control_object, arg_attribute_def.control_name AS attr_control_name, arg_security.serdid AS attr_SERDID, arg_class_def.extensible AS class_extensible,       arg_class_def.customizable AS class_customizable, arg_attribute_def.extensible AS attr_extensible, arg_attribute_def.customizable AS attr_customizable, arg_attribute_def.related_base_attribute FROM arg_controls CONTROLS_1 INNER JOIN arg_security SECURITY_1 ON CONTROLS_1.cnid = SECURITY_1.secnid RIGHT OUTER JOIN arg_class_def INNER JOIN arg_attribute_def ON arg_class_def.class_name = arg_attribute_def.class_name ON CONTROLS_1.cnobject = arg_class_def.control_object AND CONTROLS_1.cnname = arg_class_def.control_name LEFT OUTER JOIN arg_security INNER JOIN arg_controls ON arg_security.secnid = arg_controls.cnid ON SECURITY_1.serdid = arg_security.serdid AND arg_attribute_def.control_object = arg_controls.cnobject AND arg_attribute_def.control_name = arg_controls.cnname

GO
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_class_attribute_sec_view] TO [uapmreporting_group]
GO