Re: adding comments to a table - update

From: "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com>
To: "pg-general (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: adding comments to a table - update
Date: 2003-06-05 17:34:47
Message-ID: 73309C2FDD95D11192E60008C7B1D5BB05FED3E0@snt452.corp.bcbsm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Sullivan 2003-06-05 18:14:14 Re: implicit type conversions
Previous Message Avi Schwartz 2003-06-05 16:44:34 Re: Nulls get converted to 0 problem