Tables [dbo].[das_object_list]
Properties
PropertyValue
CollationSQL_Latin1_General_CP1_CS_AS
Row Count0
Created11:07:11 AM Wednesday, March 07, 2007
Last Modified11:09:36 AM Wednesday, March 07, 2007
Columns
NameData TypeMax Length (Bytes)Allow Nulls
Indexes $das_o_u00001a2f00000000: hostid\serverid\objectname\objecttypeobjectnamevarchar(255)255
No
Indexes $das_o_u00001a2f00000000: hostid\serverid\objectname\objecttypeobjecttypedecimal(5,0)5
No
Indexes $das_o_u00001a2f00000000: hostid\serverid\objectname\objecttypehostiddecimal(10,0)9
No
Indexes $das_o_u00001a2f00000000: hostid\serverid\objectname\objecttypeserveriddecimal(10,0)9
No
objectdbnamevarchar(255)255
Yes
name1varchar(255)255
Yes
nametype1varchar(255)255
Yes
name2varchar(255)255
Yes
nametype2varchar(255)255
Yes
listtypeint4
No
objectownervarchar(255)255
No
Cluster Primary Key pk_das_object_list: listobjectid\anlydefid\actionid\policyidlistobjectiddecimal(10,0)9
No
Cluster Primary Key pk_das_object_list: listobjectid\anlydefid\actionid\policyidanlydefiddecimal(10,0)9
No
Cluster Primary Key pk_das_object_list: listobjectid\anlydefid\actionid\policyidactioniddecimal(10,0)9
No
Cluster Primary Key pk_das_object_list: listobjectid\anlydefid\actionid\policyidpolicyiddecimal(10,0)9
No
Indexes Indexes
NameColumnsUnique
Cluster Primary Key pk_das_object_list: listobjectid\anlydefid\actionid\policyidpk_das_object_listlistobjectid, anlydefid, actionid, policyid
Yes
$das_o_u00001a2f00000000hostid, serverid, objectname, objecttype
Yes
Permissions
TypeActionOwning Principal
GrantDeleteudmadmin_group
GrantInsertudmadmin_group
GrantSelectudmadmin_group
GrantUpdateudmadmin_group
SQL Script
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
Uses