Navigation: iVend Database Database > Tables >
iVend 6.6 Database Help
SecSecurityRole Table
Collapse All Expand All
iVend Database Database : SecSecurityRole Table |
Description
The details of the security role and associated rights over the security functions (different objects )e.g.GoodReceipt are specified here .In different roles we can give different rights to the predefined security functions. e.g. for an employee the role can be just to read all the security functions and for manager the role must have full rights to all the security functions.
Properties
Creation Date |
4/13/2015 12:00 PM |
File Group |
PRIMARY |
Text File Group |
|
System Object |
|
Published for Replication |
|
Rows |
1 |
Data Space Used |
8.00 KB |
Index Space Used |
8.00 KB |
Columns
|
Column Name |
Description |
Datatype |
Length |
Allow Nulls |
Default |
Formula |
|
SecurityRoleKey |
Value is the system generated Primary Key of the table. |
VarWChar |
50 |
|
|
|
|
Id |
Value is the id of the security role. |
VarWChar |
20 |
|
|
|
|
Description |
Value is the description of the security role. |
VarWChar |
100 |
|
|
|
|
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 |
|
|
|
|
DisplayProfileKey |
Reference key for the Display profile. See Display profile |
VarWChar |
50 |
|
|
|
|
CanAssignAtStore |
Flag to check whether role can be assigned from store. |
Boolean |
1 |
|
((1)) |
|
Indexes
Index |
Description |
Primary |
Unique |
|
|
|
SQL
SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON CREATE TABLE [dbo].[SecSecurityRole]( [SecurityRoleKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Id] [nvarchar](20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Description] [nvarchar](100) COLLATE SQL_Latin1_General_CP1_CI_AS 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, [DisplayProfileKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CanAssignAtStore] [bit] NULL, CONSTRAINT [PK_SecSecurityRole] PRIMARY KEY CLUSTERED ( [SecurityRoleKey] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] ALTER TABLE [dbo].[SecSecurityRole] ADD CONSTRAINT [DF_SecSecurityRole_CanAssignAtStore] DEFAULT ((1)) FOR [CanAssignAtStore] |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.