Forwarded without comment; this remote connection is too slow to want
to check into it.  I doubt the shmem failure is due to the GRANT thing
though.  Has anyone ever seen that before?

			regards, tom lane


------- Forwarded Message

Date:    Mon, 14 Aug 2000 08:03:33 -0700 (PDT)
From:    Marius Andreiana <mandreiana@yahoo.com>
To:      tgl@sss.pgh.pa.us
Subject: Bugs with GRANT ?

Hello, please forward this to pg devel list, I'm
not subscribed. Got your address on the website.
Thanks for help!

Hi, I'm using postgresql 7.02

Here's the problem : I created an user "marius" with
create database permission. From now on I work with
"marius".

I created a database, populated, ... Now in psql :

\z 
	lists objects and Access permissions column is empty.
grant select on members to me;
	CHANGE
\z
	members' permissions are {"=","me=r"}
select * from member;
	ERROR:  members: Permission denied.


So, when granting a permission to another user, the
owner of the database
looses the ALL permission he has on that object; even
after revoking
the perm, it's shown as {"="} and nobody can access it
(I have to use GRANT to give the owner the permission)

I don't think this is right, is it ? IMHO, the owner
of the database
has always ALL permission on all objects, and I can't
mess with that.
(nor GRANT, neither REVOKE)

2 minutes later I shut down postmaster as usual, then
when trying to 
start it I get

000812.12:50:04.683   [991] IpcMemoryCreate: shmget
failed (Identifier removed) key=5432010, size=144,
permission=700
This type of error is usually caused by an improper
shared memory or System V IPC semaphore configuration.
For more information, see the FAQ and
platform-specific
FAQ's in the source directory pgsql/doc or on our
web site at http://www.postgresql.org.
000812.12:50:04.766   [991] IpcMemoryIdGet: shmget
failed (Identifier removed) key=5432010, size=144,
permission=0
000812.12:50:04.796   [991] IpcMemoryAttach: shmat
failed (Invalid argument) id=-2
000812.12:50:04.822   [991] FATAL 1: 
AttachSLockMemory: could not attach segment

This never happened to me, I use postgres from 6.5
version; could this be
because of the same GRANT/REVOKE ? (strange
coincidence if not...)
After reinstalling postgres, it still didn't worked
(same error). After
restarting the machine (Linux 2.2.14) it worked.

Thanks,
Marius

------- End of Forwarded Message

Mon, 14 Aug 2000 17:15:00 -0400
Tom Lane <tgl@sss.pgh.pa.us>
FWD: Bugs with GRANT ?