--belay that .... i just found the info from the PostgreSQL
--site ... it says:
[snip]
It should be noted that there is presently no security
mechanism for comments: any user connected to a
database can see all the comments for objects in that
database (although only superusers can change comments
for objects that they don't own). Therefore, don't put
security-critical information in comments.
[/snip]
--thanks anyways.
-X
-----Original Message-----
From: Johnson, Shaunn
Sent: Thursday, June 05, 2003 11:18 AM
To: pg-general (E-mail)
Subject: [GENERAL] adding comments to a table
Howdy:
Running PostgreSQL 7.2.1 on RedHat Linux 7.2.
I have a table where I'm the owner, but I want to give
all permission to another person. So, I do a
'grant all on <table> to <joe_user>' and it seems that
they have all the rights that I do.
But they are not able to add a comment to the table.
Is this a table creator-only ability? How can I give
the new person the ability to add a comment to
the table?
Thanks!
-X
