Edwin UY <edwin(dot)uy(at)gmail(dot)com> writes:
> Just playing around here trying and 'confused' what the GRANT USAGE ON
> SCHEMA is supposed to be for?
> I thought it was supposed to all 'full' access of one schema to the other
No. Schema USAGE is more or less like directory read permissions in
a file system: it lets you get to the contained objects. You also
need appropriate permissions on the contained objects in order to
do anything with them.
regards, tom lane