Set DEFAULT privilege for a database


Is there a feature to set default privilege for a database, so that newly created tables will be given the same grants with the old ones?

I understand CockroachDB has ROLES for easier user management in Enterprise version. But it would be a great feature for community version to have default privileges.

This document for Postgres might explain better


Hi @masaisai,

We have recently been discussing GRANTS for users, I will certainly let your team know and will share any github issue we decide to create around this.


I see. Thanks for the info.