On 6/13/20 10:33 AM, sekhar chandra wrote:
> Adrian - when I follow the same steps what you did . in my case , the
> result is false.
>
>
> grant usage on schema public to role_test ;
> GRANT
>
> SELECT rolname, has_schema_privilege('role_test', 'public', 'usage')
> from pg_roles where rolname = 'role_test';
> rolname | has_schema_privilege
> -----------+----------------------
> role_test | f
>
Might be a good time to point out :) :
https://www.postgresql.org/docs/12/ddl-schemas.html#DDL-SCHEMAS-PUBLIC
" Note that by default, everyone has CREATE and USAGE privileges on the
schema public. This allows all users that are able to connect to a given
database to create objects in its public schema. "
--
Adrian Klaver
adrian.klaver@aklaver.com