[dbo].[usersec

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

	Name	Data Type	Max Length (Bytes)
$Indexes baseidx_usersec_profile: node\id$	node	varchar(64)	64
$Indexes baseidx_usersec_profile: node\id$	id	varchar(32)	32
	uid	int	4
	gid	int	4
	platform	varchar(8)	8
	ugroupname	varchar(20)	20
	ownerid	varchar(20)	20
	name	varchar(255)	255
	home	varchar(255)	255
	shell	varchar(255)	255
	domain	varchar(32)	32
	phone	varchar(14)	14
	datefmt	varchar(11)	11
	dateseparator	char(1)	1
	decpoint	char(1)	1
	ccase	char(1)	1
	nlscode	char(2)	2
	resparea	char(3)	3
	probesc	varchar(6)	6
	effdate	int	4
	expdate	int	4
	loginoption	varchar(12)	12
	logincnt	int	4
	critprof	varchar(20)	20
	calendar	varchar(20)	20
	defsesid	varchar(15)	15
	lldate	int	4
	lltime	int	4
	llpid	varchar(5)	5
	llnode	varchar(64)	64
	llsource	varchar(32)	32
	password	varchar(32)	32
	pwddate	int	4
	pwdtime	int	4
	pwdpid	varchar(5)	5
	pwdnode	varchar(64)	64
	pwduser	varchar(32)	32
	pwdsource	varchar(32)	32
	pwdexpdate	int	4
	pwdchange	varchar(8)	8
	pwdqsize	int	4
	pwdchgmindays	int	4
	pwdchgmaxdays	int	4
	pwdmask1	varchar(13)	13
	pwdmask2	varchar(13)	13
	pwdviodate	int	4
	pwdviotime	int	4
	pwdvionode	varchar(64)	64
	pwdviouser	varchar(32)	32
	pwdviosource	varchar(32)	32
	pwdviocount	int	4
	violmode	varchar(8)	8
	violaction	varchar(16)	16
	viodate	int	4
	viotime	int	4
	viopid	varchar(5)	5
	vionode	varchar(64)	64
	viouser	varchar(32)	32
	viosource	varchar(32)	32
	viocount	int	4
	status	varchar(8)	8
	susdate	int	4
	sustime	int	4
	suspid	varchar(5)	5
	susnode	varchar(64)	64
	sususer	varchar(32)	32
	sussource	varchar(32)	32
	suscount	int	4
	tmoutintv	varchar(8)	8
	tmodate	int	4
	tmotime	int	4
	tmopid	varchar(5)	5
	tmonode	varchar(64)	64
	tmosource	varchar(32)	32
	tmocount	int	4
	updatedate	int	4
	updatetime	int	4
	updatepid	varchar(5)	5
	updatenode	varchar(64)	64
	updateuser	varchar(32)	32
	updatesource	varchar(32)	32
	createdate	int	4
	createtime	int	4
	createpid	varchar(5)	5
	createnode	varchar(64)	64
	createuser	varchar(32)	32
	createsource	varchar(32)	32
	violaction_c	char(1)	1
	violaction_l	char(1)	1
	violaction_s	char(1)	1
	suspended	char(3)	3
	upsstat	varchar(20)	20
	userorigin	varchar(12)	12
	extraint1	int	4
	extraint2	int	4
	extraint3	int	4
	extraint4	int	4
	extraint5	int	4
	extraint6	int	4
	extraint7	int	4
	extraint8	int	4
	extravarchar1	varchar(2)	2
	extravarchar2	varchar(4)	4
	extravarchar3	varchar(6)	6
	extravarchar4	varchar(8)	8
	extravarchar5	varchar(10)	10
	extravarchar6	varchar(20)	20
	extravarchar7	varchar(60)	60

Name	Columns
baseidx_usersec_profile	node, id
usersec_profile_idx_01	node

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

SQL Script

CREATE TABLE [dbo].[usersec_profile]
(
[node] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[id] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL,
[uid] [int] NULL,
[gid] [int] NULL,
[platform] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ugroupname] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ownerid] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[name] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[home] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[shell] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[domain] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[phone] [varchar] (14) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[datefmt] [varchar] (11) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[dateseparator] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[decpoint] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[ccase] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[nlscode] [char] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[resparea] [char] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[probesc] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[effdate] [int] NULL,
[expdate] [int] NULL,
[loginoption] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[logincnt] [int] NULL,
[critprof] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[calendar] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[defsesid] [varchar] (15) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[lldate] [int] NULL,
[lltime] [int] NULL,
[llpid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[llnode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[llsource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[password] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwddate] [int] NULL,
[pwdtime] [int] NULL,
[pwdpid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdnode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwduser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdsource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdexpdate] [int] NULL,
[pwdchange] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdqsize] [int] NULL,
[pwdchgmindays] [int] NULL,
[pwdchgmaxdays] [int] NULL,
[pwdmask1] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdmask2] [varchar] (13) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdviodate] [int] NULL,
[pwdviotime] [int] NULL,
[pwdvionode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdviouser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdviosource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[pwdviocount] [int] NULL,
[violmode] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[violaction] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[viodate] [int] NULL,
[viotime] [int] NULL,
[viopid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[vionode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[viouser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[viosource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[viocount] [int] NULL,
[status] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[susdate] [int] NULL,
[sustime] [int] NULL,
[suspid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[susnode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sususer] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[sussource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[suscount] [int] NULL,
[tmoutintv] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tmodate] [int] NULL,
[tmotime] [int] NULL,
[tmopid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tmonode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tmosource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[tmocount] [int] NULL,
[updatedate] [int] NULL,
[updatetime] [int] NULL,
[updatepid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatenode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updateuser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[updatesource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createdate] [int] NULL,
[createtime] [int] NULL,
[createpid] [varchar] (5) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createnode] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createuser] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[createsource] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[violaction_c] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[violaction_l] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[violaction_s] [char] (1) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[suspended] [char] (3) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[upsstat] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[userorigin] [varchar] (12) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extraint1] [int] NULL,
[extraint2] [int] NULL,
[extraint3] [int] NULL,
[extraint4] [int] NULL,
[extraint5] [int] NULL,
[extraint6] [int] NULL,
[extraint7] [int] NULL,
[extraint8] [int] NULL,
[extravarchar1] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar2] [varchar] (4) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar3] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar4] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar5] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar6] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CS_AS NULL,
[extravarchar7] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CS_AS NULL
) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [usersec_profile_idx_01] ON [dbo].[usersec_profile] ([node]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [baseidx_usersec_profile] ON [dbo].[usersec_profile] ([node], [id]) ON [PRIMARY]
GO
GRANT SELECT ON  [dbo].[usersec_profile] TO [emadmin]
GRANT INSERT ON  [dbo].[usersec_profile] TO [emadmin]
GRANT DELETE ON  [dbo].[usersec_profile] TO [emadmin]
GRANT UPDATE ON  [dbo].[usersec_profile] TO [emadmin]
GRANT SELECT ON  [dbo].[usersec_profile] TO [emuser]
GRANT SELECT ON  [dbo].[usersec_profile] TO [uniadmin]
GRANT INSERT ON  [dbo].[usersec_profile] TO [uniadmin]
GRANT DELETE ON  [dbo].[usersec_profile] TO [uniadmin]
GRANT UPDATE ON  [dbo].[usersec_profile] TO [uniadmin]
GRANT SELECT ON  [dbo].[usersec_profile] TO [uniuser]
GO