Table Sec_Access_Keys

Entity

Entity: Systems.Security.AccessKeys

Access keys provide the basic locking mechanism for data security. Each record can be secured by specifying an access key. Then the users are given access to access keys through groups. Entity: Sec_Access_Keys

Summary

Name	Type	Description
Access_Key_Code	nvarchar(16)	Unique code for the access key. The codes can be null for legacy keys or entities that do not support codes. The codes are unique only among non-null entries
Access_Key_Id	uniqueidentifier PK
Access_Key_Name	nvarchar(1024) ML	Multilanguage descriptive name of the security key. Can be null for legacy keys
Entity_Name	nvarchar(64)	What entitity the key secures. Can be null for private, legacy keys
Row_Version	timestamp

Columns

Access_Key_Code

Unique code for the access key. The codes can be null for legacy keys or entities that do not support codes. The codes are unique only among non-null entries

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	16
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(16) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Access_Key_Code - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no
Like	None	no	no

Access_Key_Id

Property	Value
Auto Complete	no
Data Filter	no
Default Value	NewGuid
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	yes (order: 1)
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	yes
Type	uniqueidentifier
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no

Access_Key_Id - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	no	no

Access_Key_Name

Multilanguage descriptive name of the security key. Can be null for legacy keys

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	1024
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(1024) (MultiLanguage) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Access_Key_Name - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no
Like	None	no	no

Entity_Name

What entitity the key secures. Can be null for private, legacy keys

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	yes
Max Length	64
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	yes
Summary Type	None
Supports EQUALS_IN	no
Type	nvarchar(64) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Entity_Name - Supported Filters

Filter Type	Default	Include Nulls	Hidden by Default
Equals	NULL	yes	no
Like	None	no	no

Row_Version

Property	Value
Auto Complete	no
Data Filter	no
Default Value	None
Enter Stop	yes
Ignore for Insert Order	no
Is Entity Name	no
Max Length	-1
Order	2147483647
Ownership Reference	no
Pasword	no
Picture	no
Primary Key	no
Readonly	no
RTF	no
Sortable	no
Summary Type	None
Supports EQUALS_IN	no
Type	timestamp
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	no