Download the PHP package govtnz/silverstripe-sqlexplorer without Composer
On this page you can find all versions of the php package govtnz/silverstripe-sqlexplorer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download govtnz/silverstripe-sqlexplorer
More information about govtnz/silverstripe-sqlexplorer
Files in govtnz/silverstripe-sqlexplorer
Package silverstripe-sqlexplorer
Short Description A SilverStripe module to provide read-only access to a database for suitably privileged users.
License BSD-3-Clause
Homepage http://github.com/govtnz/silverstripe-sqlexplorer
Informations about the package silverstripe-sqlexplorer
Introduction
SQL Explorer is a simple module that provides read-only access to database tables, and read-only SQL statements. It is intended for deployment in production environments, with restricted user access.
The tools is designed to facilite adhoc queries on a production database, where access is otherwise limited.
WARNING
Before installing this module, it is recommended that you consult with technical governance within your organisation as applicable.
Restrictions
The tool imposes some restrictions from a security perspective:
- SQL statements must be SELECT statements.
- Certain table columns are excluded automatically from results, such as password hashes, salt, etc. In a future release this may be configurable.
Configuration
No configuration is required. However, you can set the following in config.yml:
- require_explicit_permission if truthy, the SQL Explorer admin interface requires users explicitly have SQL_EXPLORER persmission. Without this extra control, any administrator can access it directly, which in some environment is undesirable. Default is false.
Future state:
- Whitelist/blacklist specific tables or columns on tables.