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

General Bug Report: "Create User TestUser IN GROUP group_name" does not add the user to the group.

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 (view raw or flat)
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:
---------


--------------------------------------------------------------------------


pgsql-bugs by date

Next:From: Jelle RuttenbergDate: 1999-05-07 07:24:50
Subject: int8-datatype: possible bug
Previous:From: Chris HowellDate: 1999-05-04 18:04:31
Subject: failure of postmaster during installation

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