Thread

1. Privileges

   Marc G. Fournier <scrappy@hub.org> — 1998-05-24T03:42:00Z

   Hello all,
   
   I have a couple of questions for you:
   
   We are trying to setup a "group" in our database... groupx.
   I found the syntax in the FAQ, from the PostgreSQL homepage.  
   So, we followed the syntax and created the group:
   
   insert into pg_group values ('groupx', '1234', {5678, 9876});
   
   It worked.  We now have a group, groupx.  Then, we granted permissions to
   that group for a particular table, foo:
   
   grant insert on foo to group groupx;
   
   That seemed to work, too.  So, I (as part of that group, and as a user
   that did not previously have permissions to the table) then inserted some
   values into the table.  Fine.  That worked too.  Then, however, we tried
   to revoke those privileges:
   
   revoke insert on foo from group groupx;
   
   That command did not return an error, rather it said CHANGE!!!!  (without
   the exclamation marks, of course).  However, afterward, I was still able
   to insert into the table.  What gives?
   
   Also, another question:
   
   How do you check to see exactly who has permissions to any particular
   table?
   
   Thanks in advance,
   
   Bob Dusek
   
   
   

2. Re: [GENERAL] Privileges

   Billy Donahue <billy@escape.com> — 1998-05-24T04:16:42Z

   
   On Sun, 24 May 1998, The Hermit Hacker wrote:
   
   > 
   > Hello all,
   > 
   > I have a couple of questions for you:
   > 
   > How do you check to see exactly who has permissions to any particular
   > table?
   
   from psql, you can enter \z and see them, but I don't know
   about from libpq.
   
   --
   "The Funk, the whole Funk, and nothing but the Funk."
   Billy Donahue
   mailto:donahu@cooper.edu
   http://www.cooper.edu/~donahu
   
   

3. Re: [GENERAL] Privileges

   Michael <wwwadmin@wizard.ca> — 1998-05-24T05:20:39Z

   Besides \z ?
   
   The Hermit Hacker wrote:
   
   > Hello all,
   >
   > I have a couple of questions for you:
   >
   > We are trying to setup a "group" in our database... groupx.
   > I found the syntax in the FAQ, from the PostgreSQL homepage.
   > So, we followed the syntax and created the group:
   >
   > insert into pg_group values ('groupx', '1234', {5678, 9876});
   >
   > It worked.  We now have a group, groupx.  Then, we granted permissions to
   > that group for a particular table, foo:
   >
   > grant insert on foo to group groupx;
   >
   > That seemed to work, too.  So, I (as part of that group, and as a user
   > that did not previously have permissions to the table) then inserted some
   > values into the table.  Fine.  That worked too.  Then, however, we tried
   > to revoke those privileges:
   >
   > revoke insert on foo from group groupx;
   >
   > That command did not return an error, rather it said CHANGE!!!!  (without
   > the exclamation marks, of course).  However, afterward, I was still able
   > to insert into the table.  What gives?
   >
   > Also, another question:
   >
   > How do you check to see exactly who has permissions to any particular
   > table?
   >
   > Thanks in advance,
   >
   > Bob Dusek
   
   
   
   
   

4. Re: [GENERAL] Privileges

   jose' soares <sferac@bo.nettuno.it> — 1998-05-25T10:29:17Z

   On Sun, 24 May 1998, The Hermit Hacker wrote:
   <DELETED>
   > That command did not return an error, rather it said CHANGE!!!!  (without
   > the exclamation marks, of course).  However, afterward, I was still able
   > to insert into the table.  What gives?
   It works for me, I have v6.3
   > 
   > Also, another question:
   > 
   > How do you check to see exactly who has permissions to any particular
   > table?
   psql \z command
                                          Jose'