be to grant
permissions to yourself first and then to all other users?
Scott
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 5:38 PM
To: Saltsgaver, Scott
Cc: '[EMAIL PROTECTED]'
Subject: Re: [SQL] Granting of permissions on tables
"Salts
"Saltsgaver, Scott" [EMAIL PROTECTED] writes:
After I ran into this condition, the first thing I tried was to grant
permissions back to myself. PostgreSQL shot me down with a permission
denied error. So I had to log is as the superuser and then grant
permissions to myself.
Are you sure
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
Saltsgaver, Scott writes:
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?
It's a bug. Fixed for 7.1.
--
Peter
"Saltsgaver, Scott" [EMAIL PROTECTED] writes:
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.
It's a bug, or at least a misfeature. As long as you haven't done any
explicit grants or