Thread: Privileges

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

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

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

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'