[ < ] [ > ]   [ << ] [ 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.


[ < ] [ > ]   [ << ] [ Up ] [ >> ]

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