iVend Database Database > Tables > SecSecurityRoleSecuritySubFunction Table

iVend 6.6 Database Help

SecSecurityRoleSecuritySubFunction Table

Collapse All Expand All

iVend Database Database : SecSecurityRoleSecuritySubFunction Table

Description

This table defines the security rights on the sub modules granted to a specific security role.

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
SecurityRoleSecuritySubFunctionKey	Primary Key	VarWChar	50
SecurityRoleKey	Refers to the security role key	VarWChar	50
SecuritySubFunctionKey	Refers to the security sub function key	VarWChar	50
AccessLevel	Defines the access level Valid values are: None= 0 Read=1 Write=2 All=3	Integer	4
SecurityFunctionKey	Reference key of the Security Function. See also SecurityFunction	VarWChar	50
IsVisibleInMC		Boolean	1

Indexes

Index	Description	Primary	Unique
PK_SecSecurityRoleSecuritySubFunction

Objects that depend on SecSecurityRoleSecuritySubFunction

Database Object	Object Type	Description	Dep Level
GetMobileReplicationData	Stored Procedure		1
GetSecurityRoleSecuritySubFunction	Stored Procedure		1
Trg_ReplicationTransactionMobile	Trigger		1

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SecSecurityRoleSecuritySubFunction](

[SecurityRoleSecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SecurityRoleKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[SecuritySubFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[AccessLevel] [int] NOT NULL,

[SecurityFunctionKey] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[IsVisibleInMC] [bit] NULL,

CONSTRAINT [PK_SecSecurityRoleSecuritySubFunction] PRIMARY KEY CLUSTERED

(

[SecurityRoleSecuritySubFunctionKey] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

Send comments on this topic.