From: | Unprivileged user <nobody> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | General Bug Report: "Create User TestUser IN GROUP group_name" does not add the user to the group. |
Date: | 1999-05-05 16:43:10 |
Message-ID: | 199905051643.MAA00334@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Michael Davis
Your email address : mdavis(at)sevainc(dot)com
Category : runtime: back-end
Severity : serious
Summary: "Create User TestUser IN GROUP group_name" does not add the user to the group.
System Configuration
--------------------
Operating System : Red Hat 5.1
PostgreSQL version : 6.5-990428
Compiler used : gcc version 2.7.2.3
Hardware:
---------
Dual Pentium II, 128M RAM
Linux linus 2.0.34 #12 Tue Oct 6 23:24:13 MDT 1998 i686 unknown
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
The command "Create User TestUser IN GROUP group_name" does not add the user to the group. You have to " UPDATE pg_group set grolist = '{501,514,502,503,504}' where grosysid = 1;" to get groups to work. The create user should automatically add the user to the grolist of pg_group when the GROUP clause is used.
--------------------------------------------------------------------------
Test Case:
----------
Create User TestUser IN GROUP group_name;
Grant all on table_name to group group_name;
log on as TestUser;
update table_name; and you should see a permission problem.
--------------------------------------------------------------------------
Solution:
---------
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Jelle Ruttenberg | 1999-05-07 07:24:50 | int8-datatype: possible bug |
Previous Message | Chris Howell | 1999-05-04 18:04:31 | failure of postmaster during installation |