Hi,
I refered
http://www.postgresql.org/docs/8.4/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE
and
got to know that I can fetch the information about permissions on schema.
Below commands work fine:
SELECT has_schema_privilege('user1', 'mydb', 'USAGE');
SELECT
Hi, I have created below function. I am checking return value of
has_schema_privilege by using flag=f. I think this is not strong way to
make a check because if in future f becomes false my stored procedure
will work improper.
Could you tell me is there any other robust way to make sure that
On Tue, Mar 9, 2010 at 10:28 AM, Jignesh Shah
jignesh.shah1...@gmail.com wrote:
Could you tell me is there any other robust way to make sure that user1
doesn't have CREATE permissions on mydb schema?
It depends what you're worried about. If you're worried that plperl
will begin mapping booleans