postgres schema grants usage I have a database called layers. in it there are two schemas 1. how 2. base_layers

each schema has its own login name and password and both are not superusers. I want the ability to query across both schemas from within the schema logins(not using postgres superuser)



above I am running this query from the base_layers schema login and it gives me this permission denied error. if i run this query through the postgres connection it works... what is the proper way to be granting usage from schema to schema without making each login name a superuser
With a super-user, do a one-time GRANT to both logins and add WITH GRANT OPTION to the end. It sounds like the users have the ability to query their own schemas but are not allowed to grant it to others.

https://www.postgresql.org/docs/9.0/static/sql-grant.html