Menu

#470 Can't list/see/edit sequences owned by group

5.1
closed-fixed
None
5
2019-09-27
2019-05-27
No

Hi.

When a sequence is owned by a group, the sequence can't be listed in phpPgAdmin (5.1, 5.6). When the sequence es searched and listed the view of the sequence fails.

Example:

CREATE GROUP grptest;
CREATE USER usrtest;
ALTER USER usrtest WITH PASSWORD 'test1234';
GRANT grptest TO usrtest;
CREATE DATABASE dbtest OWNER grptest;

\c dbtest
CREATE SEQUENCE seqtest START 101;
-- You can see the sequence in phpPgAdmin as usrtest
ALTER SEQUENCE seqtest OWNER TO grptest;
-- Now, You can't see the sequence in phpPgAdmin as usrtest

Best regards.

Discussion

  • Robert Treat

    Robert Treat - 2019-09-27
    • status: open --> closed-fixed
    • assigned_to: Robert Treat
     

Log in to post a comment.

MongoDB Logo MongoDB