DualShield System Policies are default plus built-in, that cannot usually be removed.
Older versions of DualShield Server might have allowed a System Policy to be created by an Administrator.
Where a System Policy was manually created, it can only be deleted by manipulating the DualShield Database directly.
There are Two methods to achieve this task. Via the DualShield Administration Console, or using a dedicated SQL command shell session.
Both methods can be found detailed below.
First, using the DualShield Administration Console, search for the System Policy that you wish to remove.
From the main menu, navigate to SHORTCUTS > Check Policies.
Using the Search option here, locate the System Policy to remove, then record the "Name", as highlighted below:
Delete System Policy - Using DualShield Administration Console
Navigate to Platform > Database Servers.
In the top right corner of the console, select the Blue button "SQL CONSOLE".
A text box will appear where SQL commands can be entered directly:
Enter the following command in the textbox, then click the Blue button to EXECUTE:
select * from tbl_policy where name = 'POLICYNAMEHERE';
(replace POLICYNAMEHERE with the actual Policy Name recorded above).
The output to this command will appear beneath. Record the ID returned, for this System Policy. As below:
Then issue the following SQL command to remove this entry, referencing the same ID.
delete from tbl_policy where id = 24;
(replace 24 here for your own ID returned).
Completed successfully, you should see a result as follows. Indicating 1 Row was successfully removed.
Delete System Policy - Using a SQL Command Shell session
The following alternative method uses a dedicated SQL Shell command line session, to accomplish the same result.
Launch a Windows Command Prompt.
At the prompt, change directory to the MySQL location. By default this will be: C:\Program Files\Deepnet Dualshield\mysql\bin
Enter the following command to launch a SQL command session: mysql -u root -p
(assuming ‘root’ is being used as the default system account).
You will be prompted to then enter the root account password for SQL.
Once successfully verified, we want to target the DualShield database. Enter command: use dualshield;
DualShield Policies are created under a Table named: tbl_policy.
Enter the following command:
select * from tbl_policy where name = ‘POLICYNAMEHERE’\G
(replace POLICYNAMEHERE with the actual Policy Name recorded above).
The output to this command will appear beneath. Record the ID returned, for this System Policy. As below:
Then issue the following SQL command to remove this entry, referencing the same ID.
delete from tbl_policy where id = 3;
(replace 3 here for your own ID returned).
Completed successfully, you should see a result as follows. Indicating 1 Row was successfully removed.
Finally, returning to the DualShield Administration console, searching the System Policies, the targeted Policy should no longer appear, as it has been successfully removed from the DualShield Database.
Overview
Content Tools






