[dbo].[frs

[dbo].[frs_ip]

Properties
Columns
Indexes
Permissions
SQL Script
Uses

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

Columns

	Name	Data Type	Max Length (Bytes)	Allow Nulls
	lastip	int	4

Indexes

	Name	Columns	Unique
	XPKfrs_ip	lastip

Permissions

Type	Action	Owning Principal
Grant	Delete	uniadmin
Grant	Insert	uniadmin
Grant	Select	uniadmin
Grant	Update	uniadmin
Grant	Select	uniuser

SQL Script

CREATE TABLE [dbo].[frs_ip]
(
[lastip] [int] NOT NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[frs_ip] ADD CONSTRAINT [XPKfrs_ip] PRIMARY KEY CLUSTERED ([lastip]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[frs_ip] TO [uniadmin]
GRANT INSERT ON  [dbo].[frs_ip] TO [uniadmin]
GRANT DELETE ON  [dbo].[frs_ip] TO [uniadmin]
GRANT UPDATE ON  [dbo].[frs_ip] TO [uniadmin]
GRANT SELECT ON  [dbo].[frs_ip] TO [uniuser]
GO

Uses