CREATE TABLE [dbo].[por_objectrepos]
(
[objectkey] [int] NOT NULL,
[objecttypekey] [int] NULL,
[objectname] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ownerid] [int] NULL,
[groupowner] [int] NULL,
[ownerreadpriv] [int] NULL,
[ownerwritepriv] [int] NULL,
[ownerexecutepriv] [int] NULL,
[groupreadpriv] [int] NULL,
[groupwritepriv] [int] NULL,
[groupexecutepriv] [int] NULL,
[entreadpriv] [int] NULL,
[entwritepriv] [int] NULL,
[entexecutepriv] [int] NULL,
[creator] [int] NULL,
[createdate] [int] NULL,
[lastmodifiedby] [int] NULL,
[validationcode] [int] NULL,
[validationdatetime] [int] NULL,
[validatedby] [int] NULL,
[messagecount] [int] NULL,
[description] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lastmoddatetime] [int] NULL,
[password] [nvarchar] (254) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[por_objectrepos] ADD CONSTRAINT [XPKpor_objectrepos] PRIMARY KEY CLUSTERED ([objectkey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [objobjectname] ON [dbo].[por_objectrepos] ([objectname]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [objtypekey] ON [dbo].[por_objectrepos] ([objecttypekey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [objownerid] ON [dbo].[por_objectrepos] ([ownerid]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [objpassword] ON [dbo].[por_objectrepos] ([password]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[por_objectrepos] TO [portaldba_group]
GRANT INSERT ON  [dbo].[por_objectrepos] TO [portaldba_group]
GRANT DELETE ON  [dbo].[por_objectrepos] TO [portaldba_group]
GRANT UPDATE ON  [dbo].[por_objectrepos] TO [portaldba_group]
GRANT SELECT ON  [dbo].[por_objectrepos] TO [umpadmin]
GRANT INSERT ON  [dbo].[por_objectrepos] TO [umpadmin]
GRANT DELETE ON  [dbo].[por_objectrepos] TO [umpadmin]
GRANT UPDATE ON  [dbo].[por_objectrepos] TO [umpadmin]
GRANT SELECT ON  [dbo].[por_objectrepos] TO [umpuser]
GRANT SELECT ON  [dbo].[por_objectrepos] TO [uniadmin]
GRANT INSERT ON  [dbo].[por_objectrepos] TO [uniadmin]
GRANT DELETE ON  [dbo].[por_objectrepos] TO [uniadmin]
GRANT UPDATE ON  [dbo].[por_objectrepos] TO [uniadmin]
GRANT SELECT ON  [dbo].[por_objectrepos] TO [uniuser]
GO