On 4/4/2011 9:19 AM, Howard Cole wrote:
On 04/04/2011 2:47 PM, Andy Colson wrote:
permissions, - but how do I set up the permissions for the large
objects?
I had the same problem. and there is no grant all... there is the new
DO though. That's what I used, a simple DO expression to iterate and
update the permissions.
-Andy
Thanks Andy. As a temporary measure I am going to use the server
configuration variable lo_compat_privileges when I work out how to use
it. For the longer term, could I borrow your script for the DO :)
I dont seem to have it anymore... but here is a re-created, untested
version.
do $$
delcare r record;
begin
for r in select loid from pg_catalog.pg_largeobject loop
execute 'ALTER LARGE OBJECT ' || r.loid || ' OWNER TO andy';
end loop;
end$$;
I wanted to change the owner.. where-as you want grant... but it should
get you the idea.
-Andy
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
