<< Click to Display Table of Contents >> Navigation: iVend Database Database > Tables > SecSecurityUser Table |
Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
SecSecurityUser Table
Collapse All Expand All
iVend Database Database : SecSecurityUser Table |
Description
We can make any employee of the system as a security user and specify details like login id and password and electronic id etc in this table , who may be doing POS transactions. It is mandatory to make an employee a security user before he/she can do POS transactions.
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
PRIMARY |
System Object |
|
Published for Replication |
|
Rows |
3 |
Data Space Used |
24.00 KB |
Index Space Used |
24.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
SecurityUserKey |
Value is the system generated Primary Key of the table. |
VarWChar |
50 |
|
|
|
|
|
Id |
Value is the Id of the security user. |
VarWChar |
20 |
|
|
|
|
ElectronicId |
Value is the electronic code of the user available on the magnetic card. |
VarWChar |
40 |
|
|
|
|
SecurityRoleKey |
Value is the selected key out of the security roles defined. See also Security Role |
VarWChar |
50 |
|
|
|
|
MustUseMagneticCard |
Value is true if the security user should not login manually and use the magnetic card to login. |
Boolean |
1 |
|
|
|
|
Password |
Value is the pasword to be entered while loging in manually. |
VarWChar |
255 |
|
|
|
|
CreatedBy |
Reference of user who has created this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Created |
Date of creation of this record |
DBTimeStamp |
4 |
|
|
|
|
ModifiedBy |
Reference of user who has modified this record. See also Security User |
VarWChar |
50 |
|
|
|
|
Modified |
Date of last modification of this record |
DBTimeStamp |
4 |
|
|
|
|
UserKey |
Value is the selected employee key who is being made as security user. See also Employee |
VarWChar |
50 |
|
|
|
|
IsActive |
Value is true if the security user is active. |
Boolean |
1 |
|
|
|
|
IsDeleted |
Value is True if the record has been deleted from the system. Record is always Soft Deleted |
Boolean |
1 |
|
|
|
|
CanChangePassword |
Value is true if the user can change the password |
Boolean |
1 |
|
((1)) |
|
|
ChangePasswordOnNextLogon |
Value is true if it is mandatory for the user to change the password on next logon |
Boolean |
1 |
|
((0)) |
|
|
Password1 |
Stores the user password |
VarWChar |
255 |
|
|
|
|
Password2 |
Stores the user password |
VarWChar |
255 |
|
|
|
|
Password3 |
Stores the user password |
VarWChar |
255 |
|
|
|
|
Password4 |
Stores the user password |
VarWChar |
255 |
|
|
|
|
FailureCount |
Store the value as number of times the incorrect password entered by user. |
Integer |
4 |
|
((0)) |
|
|
IsLocked |
Value is true if the user is locked due to incorrect password entries |
Boolean |
1 |
|
((0)) |
|
|
IsPasswordHashed |
Value is true if password is hashed (encrypted) |
Boolean |
1 |
|
((0)) |
|
|
HasPasswordExpired |
Value is true if the User password is expired |
Boolean |
1 |
|
((0)) |
|
|
LastPasswordChangedOn |
Stores the date when the user has updated/changed the password |
DBTimeStamp |
4 |
|
(getdate()) |
|
|
LockOutTime |
Specifies the time by long a user will be locked out |
DBTimeStamp |
4 |
|
|
|
|
Finger1 |
Stores the Finger Print |
Integer |
4 |
|
((0)) |
|
|
Finger2 |
Stores the Finger Print |
Integer |
4 |
|
((0)) |
|
|
FingerPrint1 |
Stores the Finger Print Value |
LongVarBinary |
16 |
|
|
|
|
FingerPrint2 |
Stores the Finger Print Value |
LongVarBinary |
16 |
|
|
|
|
SecurityUserType |
Stores the value for the Security user Valid values are ProductionUser = 0 TrainingUser = 1 Both = 2 |
Integer |
4 |
|
((0)) |
|
|
TrainingDatabase |
Stores the Training Database name |
VarWChar |
255 |
|
|
|
|
IsEnterpriseAccessible |
Value is True if the user is allowed to access the Enterprise |
Boolean |
1 |
|
((0)) |
|
|
IsDomainUser |
Value is True if the user is Domain user |
Boolean |
1 |
((0)) |
|
|
|
DomainUserName |
Stores the UserName for a domain |
VarWChar |
100 |
|
|
|
|
DomainUserFirstName |
Stores the Domain user first name |
VarWChar |
50 |
|
|
|
|
DomainUserLastName |
Stores the Domain user last name |
VarWChar |
50 |
|
|
|
|
AllowDashboardWebViewer |
Value is true if the user can view the dashboard |
Boolean |
1 |
|
|
|
|
IsManagementConsoleUser |
Value is true if the user is management console user and allowed to login at management console |
Boolean |
1 |
|
|
|
|
IsEnterpriseUser |
Value is true if the user is an enterprise user to login at enterprise |
Boolean |
1 |
|
|
|
|
Samname |
Stores the SAMName for the user in domain |
VarWChar |
50 |
|
|
|
|
IsAPIAuthenticationUser |
Value is true if the user is authorized for the API also |
Boolean |
1 |
|
|
|
|
StoreKey |
Reference key for the store. See Store. |
VarWChar |
50 |
((0)) |
|
|
|
HasLicense |
Value is true if the User is assigned a license |
Boolean |
1 |
((0)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
|
|
Objects that depend on SecSecurityUser
|
Database Object |
Object Type |
Description |
Dep Level |
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
||
Stored Procedure |
|
1 |
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SecSecurityUser]( [SecurityUserKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [ElectronicId] [nvarchar](40) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [SecurityRoleKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [MustUseMagneticCard] [bit] NOT NULL, [Password] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [CreatedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Created] [datetime] NOT NULL, [ModifiedBy] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Modified] [datetime] NOT NULL, [UserKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [IsActive] [bit] NOT NULL, [IsDeleted] [bit] NOT NULL, [CanChangePassword] [bit] NOT NULL, [ChangePasswordOnNextLogon] [bit] NOT NULL, [Password1] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Password2] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Password3] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [Password4] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [FailureCount] [int] NOT NULL, [IsLocked] [bit] NOT NULL, [IsPasswordHashed] [bit] NOT NULL, [HasPasswordExpired] [bit] NOT NULL, [LastPasswordChangedOn] [datetime] NOT NULL, [LockOutTime] [datetime] NULL, [Finger1] [int] NOT NULL, [Finger2] [int] NOT NULL, [FingerPrint1] [image] NULL, [FingerPrint2] [image] NULL, [SecurityUserType] [int] NOT NULL, [TrainingDatabase] [nvarchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IsEnterpriseAccessible] [bit] NOT NULL, [IsDomainUser] [bit] NULL, [DomainUserName] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DomainUserFirstName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [DomainUserLastName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [AllowDashboardWebViewer] [bit] NULL, [IsManagementConsoleUser] [bit] NULL, [IsEnterpriseUser] [bit] NULL, [Samname] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [IsAPIAuthenticationUser] [bit] NULL, [StoreKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [HasLicense] [bit] NULL, CONSTRAINT [PK_SecSecurityUser] PRIMARY KEY CLUSTERED ( [SecurityUserKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_CanChangePassword] DEFAULT ((1)) FOR [CanChangePassword] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_ChangePasswordOnNextLogon] DEFAULT ((0)) FOR [ChangePasswordOnNextLogon] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_FailureCount] DEFAULT ((0)) FOR [FailureCount] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_IsLocked] DEFAULT ((0)) FOR [IsLocked] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_IsPasswordHashed] DEFAULT ((0)) FOR [IsPasswordHashed] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_HasPasswordexpired] DEFAULT ((0)) FOR [HasPasswordExpired] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_LastPasswordChangedOn] DEFAULT (getdate()) FOR [LastPasswordChangedOn] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_Finger1] DEFAULT ((0)) FOR [Finger1] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_Finger2] DEFAULT ((0)) FOR [Finger2] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_IsTrainingUser] DEFAULT ((0)) FOR [SecurityUserType] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_IsEnterpriseAccessible] DEFAULT ((0)) FOR [IsEnterpriseAccessible] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_IsDomainUser] DEFAULT ((0)) FOR [IsDomainUser] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_StoreKey] DEFAULT ((0)) FOR [StoreKey] ALTER TABLE [dbo].[SecSecurityUser] ADD CONSTRAINT [DF_SecSecurityUser_HasLicense] DEFAULT ((0)) FOR [HasLicense] |
See Also
© 2019 All Rights Reserved.
Send comments on this topic.