Thread: Re: adding comments to a table - update

--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