[dbo].[por_documentgroups]

Property	Value
Row Count	0
Created	12:31:10 PM Sunday, December 05, 2010
Last Modified	12:31:10 PM Sunday, December 05, 2010

	Name	Data Type	Max Length (Bytes)	Allow Nulls
$Cluster Primary Key XPKpor_documentgroups: objectkey\groupowner$	objectkey	int	4
$Cluster Primary Key XPKpor_documentgroups: objectkey\groupowner$	groupowner	int	4

	Name	Columns	Unique
$Cluster Primary Key XPKpor_documentgroups: objectkey\groupowner$	XPKpor_documentgroups	objectkey, groupowner

Type	Action	Owning Principal
Grant	Insert	uniadmin
Grant	Delete	portaldba_group
Grant	Insert	portaldba_group
Grant	Delete	umpadmin
Grant	Insert	umpadmin
Grant	Delete	uniadmin
Grant	Select	portaldba_group
Grant	Update	portaldba_group
Grant	Select	umpadmin
Grant	Update	umpadmin
Grant	Select	umpuser
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[por_documentgroups]
(
[objectkey] [int] NOT NULL,
[groupowner] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[por_documentgroups] ADD CONSTRAINT [XPKpor_documentgroups] PRIMARY KEY CLUSTERED ([objectkey], [groupowner]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[por_documentgroups] TO [portaldba_group]
GRANT INSERT ON  [dbo].[por_documentgroups] TO [portaldba_group]
GRANT DELETE ON  [dbo].[por_documentgroups] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[por_documentgroups] TO [portaldba_group]
GRANT SELECT ON  [dbo].[por_documentgroups] TO [umpadmin]
GRANT INSERT ON  [dbo].[por_documentgroups] TO [umpadmin]
GRANT DELETE ON  [dbo].[por_documentgroups] TO [umpadmin]
GRANT UPDATE ON  [dbo].[por_documentgroups] TO [umpadmin]
GRANT SELECT ON  [dbo].[por_documentgroups] TO [umpuser]
GRANT SELECT ON  [dbo].[por_documentgroups] TO [uniadmin]
GRANT INSERT ON  [dbo].[por_documentgroups] TO [uniadmin]
GRANT DELETE ON  [dbo].[por_documentgroups] TO [uniadmin]
GRANT UPDATE ON  [dbo].[por_documentgroups] TO [uniadmin]
GRANT SELECT ON  [dbo].[por_documentgroups] TO [uniuser]
GO