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