[dbo].[scc_managed_cfg_prop]
CREATE TABLE [dbo].[scc_managed_cfg_prop]
(
[assettype] [char] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[by_srm] [tinyint] NOT NULL,
[by_san] [tinyint] NULL,
[by_bab] [tinyint] NULL,
[by_vantage] [tinyint] NULL,
[by_babld] [tinyint] NULL,
[by_tsm] [tinyint] NULL,
[by_reserve] [tinyint] NULL,
[by_other] [tinyint] NULL,
[period] [int] NOT NULL
) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [baseidx_scc_managed_cfg_prop] ON [dbo].[scc_managed_cfg_prop] ([assettype]) ON [PRIMARY]
GO
GRANT REFERENCES ON [dbo].[scc_managed_cfg_prop] TO [sccadmingroup]
GRANT SELECT ON [dbo].[scc_managed_cfg_prop] TO [sccadmingroup]
GRANT INSERT ON [dbo].[scc_managed_cfg_prop] TO [sccadmingroup]
GRANT DELETE ON [dbo].[scc_managed_cfg_prop] TO [sccadmingroup]
GRANT UPDATE ON [dbo].[scc_managed_cfg_prop] TO [sccadmingroup]
GRANT SELECT ON [dbo].[scc_managed_cfg_prop] TO [sccusergroup]
GO
