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