Views [dbo].[vCustomerInformation]
BUILD07\MSSQLSERVER2008 > MoversSuite2 > Views > dbo.vCustomerInformation
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created2:06:55 PM Friday, July 7, 2017
Last Modified2:10:00 PM Friday, July 7, 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 12 July 2017 12:28
Copyright  2017 - All Rights Reserved