| 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: | Whole Thread | Raw Message | 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) |