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.