Time for action – limiting database table access

In order to clean up the appearance and to heighten security, we will remove the table navigation display from the left side of the screen and change settings that control access to the tables in the Moodle database. Follow these steps:

1. Once again, open the conf.ini file found in the CIMS directory located inside your Moodle directory. The [_tables] list, that you will see inside this file, is what controls the tables being displayed in the navigation column. This [_tables] heading only controls the display however, and even if a table is removed from this list, the table can still be accessed by typing the table name into the browser window. We will use the following two directives to either display a table or prevent access to it: [_tables] and [_disallowed_tables].

2. The [_tables] directive formatting requires the table be identified first and then given a title as in mdl_user = "Users". Add the tables that you wish to allow to this section...