proposal: custom variables management

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

Responses

Browse pgsql-hackers by date

  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)