Views [dbo].[vCustomerInformation]
BUILD07\MSSQLSERVER2008 > MoversSuite2 > Views > dbo.vCustomerInformation
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:20:32 AM Monday, March 13, 2017
Last Modified10:22:01 AM Monday, March 13, 2017
Columns
Name
CustomerNumber
CustomerName
Permissions
TypeActionOwning Principal
GrantDeleteMssExec
GrantInsertMssExec
GrantSelectMssExec
GrantUpdateMssExec
SQL Script
CREATE view [dbo].[vCustomerInformation]
(
    CustomerNumber,
    CustomerName
)
as
select
    CustomerNumber = RM00101.CUSTNMBR,
    CustomerName = ltrim( rtrim( RM00101.CUSTNAME ) )
from CAROL..RM00101 as RM00101
GO
GRANT SELECT ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT INSERT ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT DELETE ON  [dbo].[vCustomerInformation] TO [MssExec]
GRANT UPDATE ON  [dbo].[vCustomerInformation] TO [MssExec]
GO
Uses
Used By
Created 13 March 2017 12:27
Copyright  2017 - All Rights Reserved