ERROR: permission denied for schema user1_gmail_com at character 46

You need to grant access not only to the tables in the schema, but also to the schema itself.

From the manual:

By default, users cannot access any objects in schemas they do not own. To allow that, the owner of the schema must grant the USAGE privilege on the schema.

So either make your created user the owner of the schema, or grant USAGE on the schema to this user.

Leave a Comment