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.

Reply via email to