Automatically transfer permissions when replacing a view about scenic HOT 2 CLOSED

Maybe it's helpful for anyone landing here through a web search or so: We solved this by creating a custom adapter which applies the desired permissions after each update_view.

module Scenic
  module Adapters
    class PostgresWithPermissionReapplication < Scenic::Adapters::Postgres

      def update_view(name, sql_definition)
        super

        @connectable.connection.execute <<-SQL.squish
          GRANT SELECT ON TABLE #{quote_table_name(name)} TO role
        SQL
      end
    end
  end
end

Scenic.configure do |config|
  config.database = Scenic::Adapters::PostgresWithPermissionReapplication.new
end

from scenic.

We already have a pattern for something similar with indexes on materialized views but I'm not sure we should extend it for this use case which seems unlikely to be common.

I'd encourage you to look at how Index Reapplication works to see how you might do permission re-application -- perhaps as an extension to scenic you could use.

I'm not terribly incliuned to support this inside Scenic at the moment, but I could be swayed by some combination of:

1. A number of people that need this functionality
2. An implementation that is easily understood
3. An argument convincing me this isn't a slippery slop towards supporting just about anything someone can associate with a view (if we support indexes and permissions, is there going to be something else after that?)

I'm going to close this for now given that I'm not convinced we should add and maintain this, but could revisit

from scenic.