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@xxxxxxxxxxx
