[dbo].[al_loggedin

Property	Value
Collation	SQL_Latin1_General_CP1_CI_AS
Row Count	0
Created	2:46:42 PM Saturday, July 19, 2008
Last Modified	2:46:43 PM Saturday, July 19, 2008

	Name	Data Type	Max Length (Bytes)
$Cluster Primary Key PK_al_loggedin_users: user_id\ip_address$	user_id	nvarchar(255)	510
$Cluster Primary Key PK_al_loggedin_users: user_id\ip_address$	ip_address	nvarchar(100)	200
	last_update_date	int	4

	Name	Columns	Unique
$Cluster Primary Key PK_al_loggedin_users: user_id\ip_address$	PK_al_loggedin_users	user_id, ip_address

Type	Action	Owning Principal
Grant	Delete	uapmadmin_group
Grant	Insert	uapmadmin_group
Grant	Delete	uapmbatch_group
Grant	Insert	uapmbatch_group
Grant	Delete	swcmadmin
Grant	Insert	swcmadmin
Grant	Select	uapmadmin_group
Grant	Update	uapmadmin_group
Grant	Select	uapmbatch_group
Grant	Update	uapmbatch_group
Grant	Select	uapmreporting_group
Grant	Select	swcmadmin
Grant	Update	swcmadmin

SQL Script

CREATE TABLE [dbo].[al_loggedin_users]
(
[user_id] [nvarchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[ip_address] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[last_update_date] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[al_loggedin_users] ADD CONSTRAINT [PK_al_loggedin_users] PRIMARY KEY CLUSTERED ([user_id], [ip_address]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[al_loggedin_users] TO [swcmadmin]
GRANT INSERT ON  [dbo].[al_loggedin_users] TO [swcmadmin]
GRANT DELETE ON  [dbo].[al_loggedin_users] TO [swcmadmin]
GRANT UPDATE ON  [dbo].[al_loggedin_users] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_loggedin_users] TO [uapmadmin_group]
GRANT INSERT ON  [dbo].[al_loggedin_users] TO [uapmadmin_group]
GRANT DELETE ON  [dbo].[al_loggedin_users] TO [uapmadmin_group]
GRANT UPDATE ON  [dbo].[al_loggedin_users] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_loggedin_users] TO [uapmbatch_group]
GRANT INSERT ON  [dbo].[al_loggedin_users] TO [uapmbatch_group]
GRANT DELETE ON  [dbo].[al_loggedin_users] TO [uapmbatch_group]
GRANT UPDATE ON  [dbo].[al_loggedin_users] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_loggedin_users] TO [uapmreporting_group]
GO