CascadeDelete

The CascadeDelete settings control whether the Cascade Delete button for a table is visible and/or enabled for a user in EQuIS Professional. This ST_CONFIG settings will not override Application Level Security (ALS) Permissions that would otherwise prevent having access to the Cascade Delete functionality (i.e., having less than Editor permission on the logged in facility) nor if the table is a restricted table.

CascadeDelete.Enabled

ST_CONFIG	VALUE	REMARK	VALID VALUES
CONFIG_SECTION	CascadeDelete	Required
CONFIG_KEY	Enabled	Required
OBJECT_TYPE		null
OBJECT_VALUE		null
STRING_VALUE	<string>	Choose one	Everyone OnlyDatabaseOwner

CascadeDelete.Enabled Options

There are two valid values accepted to configure CascadeDelete.Enabled:

1. OnlyDatabaseOwner – The default functionalityconfiguration. For the button to be enabled, even if the user has permission on the form, the user must be connected to the database as a member of the DB_OWNER database role.

2.Everyone – If not otherwise restricted due to ALS permissions or if the table is a restricted table, this enables the button for all users, whether the user is connected to the database as a member of the DB_OWNER role or not.

Note: The ALS role assigned to the user must be associated with a service account, via the connection string, that has delete permissions on the table of interest, else the Cascade Delete action will fail.

OnlyDatabaseOwner – The default functionality. For the button to be enabled, even if the user has permission on the form, the user must be connected to the database as a member of the DB_OWNER database role.

Example

CONFIG_SECTION	CONFIG_KEY	OBJECT_TYPE	OBJECT_VALUE	STRING_VALUE
CascadeDelete	Enabled			Everyone

CascadeDelete.Visible

ST_CONFIG	VALUE	REMARK	VALID VALUES
CONFIG_SECTION	CascadeDelete	Required
CONFIG_KEY	Visible	Required
OBJECT_TYPE		null
OBJECT_VALUE		null
STRING_VALUE		Choose One	True False IfEnabled

CascadeDelete.Visible Options

There are three valid values accepted to configure CascadeDelete.Visible:

1.True – The default functionality configuration. If not otherwise restricted due to ALS permissions or if the table is a restricted table, this displays the button for all users.

2.False – The Cascade Delete button will not be visible to any user.

3.IfEnabled – If not otherwise restricted due to ALS permissions or if the table is a restricted table, the Cascade Delete button will only be visible if it is also enabled as set by the CascadeDelete.Enabled property.

Example:

CONFIG_SECTION	CONFIG_KEY	OBJECT_TYPE	OBJECT_VALUE	STRING_VALUE
CascadeDelete	Visible			IfEnabled