PostgreSQL User Signature

Overview

The Postgres Signature module making all database connections and queries "personalized". If you have not only default database user but also SQL users with the names as Drupal users, all requests would be performed with corresponding SQL-user name.

Queries from user #1 and from anonymous users authored by default connection string.

Adding and removing Drupal users also leads to do the same on database level.

On administration pages there is a functional to create (or delete) in bulk SQL users to reflect existing Drupal users.

Supports PostgreSQL database only. Currently working on a production system with PostgreSQL version 9.1 .

Installation and usage

Install as a regular module, then visit administration pages under admin/config/people to tune default user creation command.

If needed, prior to module removal you may visit admin page and do bulk remove of SQL users which you do not need anymore.

Supported by Druler.