[dbo].[dbm

Property	Value
Collation	SQL_Latin1_General_CP1_CS_AS
Heap
Row Count	0
Created	11:07:11 AM Wednesday, March 07, 2007
Last Modified	11:07:11 AM Wednesday, March 07, 2007

Name	Data Type	Max Length (Bytes)
id	int	4
productcode	varchar(8)	8
productversion	varchar(8)	8
objecttype	varchar(12)	12
creator	varchar(50)	50
serverid	int	4
owner	varchar(50)	50
objectname	varchar(60)	60
dbname	varchar(60)	60
name	varchar(60)	60
description	varchar(255)	255
shared	smallint	2
xml	image	max

Type	Action	Owning Principal
Grant	Delete	udmadmin_group
Grant	Insert	udmadmin_group
Grant	Select	udmadmin_group
Grant	Update	udmadmin_group

SQL Script

CREATE TABLE [dbo].[dbm_guis]
(
[id] [int] NULL,
[productcode] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[productversion] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[objecttype] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[creator] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[serverid] [int] NULL,
[owner] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[objectname] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dbname] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[shared] [smallint] NULL,
[xml] [image] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[dbm_guis] TO [udmadmin_group]
GRANT INSERT ON  [dbo].[dbm_guis] TO [udmadmin_group]
GRANT DELETE ON  [dbo].[dbm_guis] TO [udmadmin_group]
GRANT UPDATE ON  [dbo].[dbm_guis] TO [udmadmin_group]
GO