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:
Once again, open the
conf.ini
file found in theCIMS
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]
.The
[_tables]
directive formatting requires the table be identified first and then given a title as inmdl_user = "Users"
. Add the tables that you wish to allow to this section...