I am not able to give usage permission to public schema. below are the steps.
Logged in as super user created a new user as user1 grant usage on public to user1 command completed successfully , but verification statement showing he doesnt have usage permission. SELECT rolname, has_schema_privilege(rolname, 'public', 'usage') from pg_roles; this is strage. what could go wrong.