Views [dbo].[vCustomerInformation]
BUILD07\MSSQLSERVER2008 > MoversSuite2 > Views > dbo.vCustomerInformation
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created1:30:49 PM Monday, June 5, 2017
Last Modified1:33:35 PM Monday, June 5, 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 06 June 2017 10:57
Copyright  2017 - All Rights Reserved