Skip to main content
1 of 3
jgomo3
  • 684
  • 1
  • 5
  • 10

PostgreSQL: What will GRANT <privilege> ON ALL TABLES IN SCHEME <scheme> TO <role> do?

It seems obvious that PostgreSQL will GRANT some privileges ON ALL TABLES IN some schema TO some role when I'll command.

But, will it make it permanent for the schema that on all tables within it, they will be granted the indicated privileges to the indicated roles, so new tables will be affected in the future?.

Or it works as a batch command so after a new table is created in the schema I have to GRANT the indicated privileges to the indicated roles again?.

jgomo3
  • 684
  • 1
  • 5
  • 10