Skip to main content
Tweeted twitter.com/#!/StackDBAs/status/484202139028561920
edited title
Link
Craig Ringer
  • 57.3k
  • 6
  • 159
  • 192

What will GRANT <privilege> ON ALL TABLES IN SCHEMESCHEMA <scheme> TO <role> do?

edited title
Link
Erwin Brandstetter
  • 182.1k
  • 28
  • 457
  • 620

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

Source Link
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?.