CascadeDelete

<< Click to Display Table of Contents >>

EQuIS 7  >>  Configuration > ST_CONFIG Entries >

CascadeDelete

The CascadeDelete settings provide additional control on whether the Cascade Delete button for a table is visible and/or enabled for a user in EQuIS Professional. It will not override Application Level Security (ALS) Permissions that would otherwise prevent access to the Cascade Delete functionality in EQuIS Professional nor will it if the table is a restricted table. However, the setting may be needed to allow some ALS users to use the button, if they are not connected as a member of the database DB_OWNER role.

 

CascadeDelete.Enabled

 

EQuIS Version: 6.0+

 

Namespace: EarthSoft.EDP

 

Products Affected: Professional

 

Requires Module: Professional

 

ST_CONFIG

VALUE

REMARK

VALID VALUES

CONFIG_SECTION

CascadeDelete

Required


CONFIG_KEY

Enabled

Required


OBJECT_TYPE


null


OBJECT_VALUE


null


STRING_VALUE

Everyone

OnlyDatabaseOwner


Choose One

 

Remarks:

 

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 1: The button could be separately set to not visible with the CascadeDelete.Visible setting, which will effectively prevent use of the button.  

Note 2: The connection to the database will still require database delete permissions on that table or the Cascade Delete action will fail.

 

OnlyDatabaseOwner - The default functionality. For the button to be enabled, even if the user has ALS 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

True

False

IfEnabled


Choose One

 

Remarks:

 

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

 

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

 

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