akp geek <akpgeek@xxxxxxxxx> writes: > I have 2 schemas , schema1 and schema 2. > 1. GRANT USAGE ON SCHEMA schema1 TO schema2; You seem to be confusing schemas and users --- they are not the same thing at all. The above grants the right to lookup objects in schema1 to the user (a/k/a role) named schema2; who doesn't necessarily have anything to do with objects in schema2. Also, although you failed to show the specific command that was failing, I suspect what you are actually running into is lack of CREATE permission not USAGE permission. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
