I have a user with all privileges granted by default in database properties. I create a new schema as postgres and table there. I expect that the user should have an access to this table but it looks like it doesn't because he also requires an access to the schema.

  • Why default db privileges are not applied on schema?
  • How to make make default privileges really default on any new schemas?
  • @dezso in pgAdmin I go to db properties - default privileges and grant everything to user. – Vlad Feb 8 '16 at 10:49
  • 1
    Please connect to your DB using psql and show the output of \ddp, as well as \dp problematic_table – dezso Feb 8 '16 at 11:00
  • How did you grant those default privileges exactly? Logged in as which user? The exact command you issued? There is a related display bug in pgAdmin: dba.stackexchange.com/a/53936/3684 (still there in v1.22.0). And please use an example user name we can work with. user is a reserved word. – Erwin Brandstetter Feb 10 '16 at 4:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.