From: | "Pavel Stehule" <pavel(dot)stehule(at)hotmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | proposal: custom variables management |
Date: | 2007-03-05 16:29:04 |
Message-ID: | BAY114-F13A8E31337F798B8A73A92F9840@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Teodor Sigaev | 2007-03-05 16:29:31 | Re: GIST and TOAST |
Previous Message | Tom Lane | 2007-03-05 16:28:06 | Re: PrivateRefCount (for 8.3) |