iVend Database Database > Tables > SecSecurityRoleSecurityFunction Table

iVend 6.6 Database Help

SecSecurityRoleSecurityFunction Table

Collapse All Expand All

iVend Database Database : SecSecurityRoleSecurityFunction Table

Description

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

Properties

Columns

Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
SecurityRoleSecurityFunctionKey	Value is the system generated Primary Key of the table.	VarWChar	50
SecurityRoleKey	Value is the securityRoleKey. See also Security Role	VarWChar	50
SecurityFunctionKey	Value is the security function key. See also Security Function	VarWChar	50
AccessLevel	Defines the access level Valid values are: None= 0 Read=1 Write=2 All=3	Integer	4
IsVisibleInMC		Boolean	1

Indexes

Index	Description	Primary	Unique
PK_SecSecurityRoleSecurityFunction

Objects that depend on SecSecurityRoleSecurityFunction

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

SQL

SET ANSI_NULLS ON

SET QUOTED_IDENTIFIER ON

CREATE TABLE [dbo].[SecSecurityRoleSecurityFunction](

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

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

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

[AccessLevel] [int] NOT NULL,

[IsVisibleInMC] [bit] NULL,

CONSTRAINT [PK_SecSecurityRoleSecurityFunction] PRIMARY KEY CLUSTERED

(

[SecurityRoleSecurityFunctionKey] 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.