CREATE TABLE [dbo].[das_object_list]
(
[objectname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[objecttype] [decimal] (5, 0) NOT NULL,
[hostid] [decimal] (10, 0) NOT NULL,
[serverid] [decimal] (10, 0) NOT NULL,
[objectdbname] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nametype1] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nametype2] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[listtype] [int] NOT NULL,
[objectowner] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[listobjectid] [decimal] (10, 0) NOT NULL,
[anlydefid] [decimal] (10, 0) NOT NULL,
[actionid] [decimal] (10, 0) NOT NULL,
[policyid] [decimal] (10, 0) NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[das_object_list] ADD CONSTRAINT [pk_das_object_list] PRIMARY KEY CLUSTERED ([listobjectid], [anlydefid], [actionid], [policyid]) ON [PRIMARY]
GO
CREATE UNIQUE NONCLUSTERED INDEX [$das_o_u00001a2f00000000] ON [dbo].[das_object_list] ([hostid], [serverid], [objectname], [objecttype]) ON [PRIMARY]
GO
GRANT SELECT ON [dbo].[das_object_list] TO [udmadmin_group]
GRANT INSERT ON [dbo].[das_object_list] TO [udmadmin_group]
GRANT DELETE ON [dbo].[das_object_list] TO [udmadmin_group]
GRANT UPDATE ON [dbo].[das_object_list] TO [udmadmin_group]
GO