Thread: [pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
[pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
From
"pgAdmin Trac"
Date:
#54: Wrong display of privileges on Procedural Language in SQL window
-------------------------------+--------------------------------------------
Reporter: Jan-Peter Seifert | Owner: dpage
Type: bug | Status: new
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: language | Platform: all
-------------------------------+--------------------------------------------
there seems to be a problem with evaluating the ACL for a procedural
language:
SQL windows says:
-- Language: plpgsql
-- DROP LANGUAGE plpgsql;
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
HANDLER plpgsql_call_handler
VALIDATOR plpgsql_validator;
ALTER LANGUAGE plpgsql OWNER TO user1;
REVOKE ALL ON LANGUAGE plpgsql FROM public;
REVOKE ALL ON LANGUAGE plpgsql FROM user2;
REVOKE ALL ON LANGUAGE plpgsql FROM user3;
The ACL in the properties window seems to say correctly:
{=U/user1,user2=U*/user1,user3=U/user1}
Happened to me on PostgreSQL 8.3.7 and pgAdmin 1.8.4/1.10.0.
Thank you very much,
Peter
P.S. Is the "=U/user1" at the beginning the entry for public?
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/54>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
From
"pgAdmin Trac"
Date:
#54: Wrong display of privileges on Procedural Language in SQL window
-------------------------------+--------------------------------------------
Reporter: Jan-Peter Seifert | Owner: Sachin Srivastava
Type: bug | Status: assigned
Priority: minor | Milestone:
Component: pgadmin | Version: 1.10
Keywords: language | Platform: all
-------------------------------+--------------------------------------------
Changes (by gleu):
* owner: dpage => Sachin Srivastava
* status: new => assigned
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/54#comment:1>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III
Re: [pgAdmin III] #54: Wrong display of privileges on Procedural Language in SQL window
From
"pgAdmin Trac"
Date:
#54: Wrong display of privileges on Procedural Language in SQL window
--------------------------------+-------------------------------------------
Reporter: Jan-Peter Seifert | Owner: Sachin Srivastava
Type: bug | Status: closed
Priority: minor | Milestone: 1.10.1
Component: pgadmin | Version: 1.10
Resolution: fixed | Keywords: language
Platform: all |
--------------------------------+-------------------------------------------
Changes (by gleu):
* status: assigned => closed
* resolution: => fixed
* milestone: => 1.10.1
Comment:
Fixed in r8017 and r8018.
--
Ticket URL: <http://code.pgadmin.org/trac/ticket/54#comment:2>
pgAdmin III <http://code.pgadmin.org/trac/>
pgAdmin III