Granting of permissions on tables - Mailing list pgsql-sql

From Saltsgaver, Scott
Subject Granting of permissions on tables
Date
Msg-id 7283DE19D141D111AD0E00A0C95B195503A59E73@mail2.aiinet.com
Whole thread Raw
Responses Re: Granting of permissions on tables
Re: Granting of permissions on tables
List pgsql-sql
I have PostgreSQL v7.02 running on a HP-UX 11.00 box.  I as the owner of
some tables granted permissions to another user.  I executed the following
command from psql

GRANT ALL on <tables here> to <user2>;

after running the command I lost permissions to the tables once I exited
psql.  I had to run psql as the postgres user to correct the situation.

Is this a bug or desired behavior?  I would imagine since I owned the tables
and then granted permissions to another user, I wouldn't lose my
permissions.

Any help or explanation would be appreciated.

Thanks,
Scott Saltsgaver



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Object syntax
Next
From: Peter Eisentraut
Date:
Subject: Re: Granting of permissions on tables