Views [dbo].[e2e_wrm_columnnamev]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created12:32:09 PM Sunday, December 05, 2010
Last Modified12:32:09 PM Sunday, December 05, 2010
Columns
Name
columnname
title
tablename
reporttitle
isvisible
presentation
formula
sortby
Permissions
TypeActionOwning Principal
GrantSelectapmadmin
SQL Script
create view  e2e_wrm_columnnamev AS
SELECT e2e_wrm_reportcolumn.columnname, e2e_wrm_reportcolumn.title,
e2e_wrm_report.tablename, e2e_wrm_report.title AS reporttitle,
e2e_wrm_reportcolumn.isvisible, e2e_wrm_reportcolumn.presentation,
e2e_wrm_reportcolumn.formula, e2e_wrm_reportcolumn.sortby
FROM  e2e_wrm_report inner JOIN  e2e_wrm_reportcolumn
ON e2e_wrm_report.reportid = e2e_wrm_reportcolumn.reportid
GO
GRANT SELECT ON  [dbo].[e2e_wrm_columnnamev] TO [apmadmin]
GO
Uses