On 12/16/2012 6:21 PM, Tom Lane wrote:
David Wall <d.wall@xxxxxxxxxxxx> writes:
On 12/16/2012 11:22 AM, Tom Lane wrote:
Large objects didn't have privileges, nor owners, in 8.4. If you
don't
feel like fixing your apps right now, you can return to the previous
behavior by setting the obscurely-named lo_compat_privileges
setting in
postgresql.conf.
I'll read up more on permissions as they relate large objects.
Okay, I cannot find any information on how to view the permissions for a
large object. I know that psql's \dp can be used to see the permissions
on a table, but how do I see the permissions assigned to a large object?
The docs show how to use GRANT/REVOKE.... ON LARGE OBJECT loid, and a
script that shows ALTER LARGE OBJECT loid OWNER TO..., but I don't see
anything about retrieving the loid's permissions.
Thanks, David
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general