Skip site navigation (1) Skip section navigation (2)

Bug in language privileges

From: Bborie Park <bkpark(at)ucdavis(dot)edu>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug in language privileges
Date: 2008-01-11 23:09:53
Message-ID: 4787F741.401@ucdavis.edu (view raw or flat)
Thread:
Lists: pgadmin-support
Howdy,

I believe there is a bug in assigning language privileges.  When 
attempting to grant privileges, all actions use REVOKE instead of GRANT. 
  For that matter, when viewing a language's details in the SQL pane, 
all privileges are displayed as REVOKE rather than GRANT though the ACL 
in the Properties tab says otherwise.

For example...

SQL pane:

-- Language: plpgsql

-- DROP LANGUAGE plpgsql;

  CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
   HANDLER plpgsql_call_handler
   VALIDATOR plpgsql_validator;
REVOKE ALL ON LANGUAGE plpgsql FROM sa;
REVOKE ALL ON LANGUAGE plpgsql FROM "\""Server Administrators\""";
REVOKE ALL ON LANGUAGE plpgsql FROM gateway;

ACL from Properties:

{sa=U/sa,"\"Server Administrators\"=U/sa",gateway=U/sa}

Thanks,
Bborie

-- 
Bborie Park
Programmer
Center for Vectorborne Diseases
UC Davis
530-752-8380
bkpark(at)ucdavis(dot)edu

Responses

pgadmin-support by date

Next:From: Bborie ParkDate: 2008-01-11 23:22:56
Subject: Re: Bug in language privileges
Previous:From: kristoffDate: 2008-01-11 17:31:28
Subject: pgagent run results. Where are they ??? :)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group