[ < ] [ > ]   [ << ] [ Up ] [ >> ]         [Top] [Contents] [Index] [ ? ]

2.3 How to change implicit settings

All Sqltutor database objects are defined in the SCHEMA sqltutor. Five output variables are defined in ‘configure.ac’ with the following implicit values.

SQLTUTOR_DATABASE=sqltutor

PostgreSQL database name used by Sqltutor.

SQLTUTOR_WWW_USER=sqlquiz

WWW user for CGI script sqlutor with full access rights to all tables.

SQLTUTOR_PASSWORD=sqlkrok

Password for CGI script for the user SQLTUTOR_WWW_USER

SQLTUTOR_WWW_EXEC=sqlexec

Database role used for running queries entered by users. SQLTUTOR_WWW_EXEC is granted SLECT to datasets’ tables and revoked all rigths on all other sqltutor tables.

SQLTUTOR_PASSEXEC=sqlkrok

Password for CGI script for the user SQLTUTOR_WWW_EXEC (implicitly the same password as for SQLTUTOR_WWW_USER).

These macros are used by all modules and you can change their implicit values if needed in the ‘configure.ac’ file.


This document was generated by Ales Cepek on January 18, 2018 using texi2html 1.82.