Hello

This proposal is about access managenent to custom variables. Currently any user can modify it, and isn't way to protect value:

Premises:
* variables are controlled from modules
* syntax of custom variables is without changes
* all modules are safe

Functions:
* reset_custom_variable(cusvar);  ... set default from postgresql.conf
* revoke_custom_variable(READ|MODIFY, cusvar, roleid);
* grant_custom_variable(READ|MODIFY, cusvar, roleid);

Related discussion:
http://archives.postgresql.org/pgsql-hackers/2007-03/msg00153.php

Regards
Pavel Stehule

_________________________________________________________________
Play Flexicon: the crossword game that feeds your brain. PLAY now for FREE.  http://zone.msn.com/en/flexicon/default.htm?icid=flexicon_hmtagline


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to