Module: PgRls::ActiveRecord::ConnectionAdapters::PostgreSQL::RlsPolicies

Includes:
SqlHelperMethod
Defined in:
lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_policies.rb

Overview

This module contains the logic to grant user privileges

Instance Method Summary collapse

Instance Method Details

#disable_table_rls(table_name, user = PgRls.username, schema = PgRls.schema) ⇒ Object 



16
17
18
19
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_policies.rb', line 16

def disable_table_rls(table_name, user = PgRls.username, schema = PgRls.schema)
  execute_sql!(drop_rls_policy_sql(schema, table_name, user))
  execute_sql!(disable_row_level_security_sql(schema, table_name))
end

#enable_table_rls(table_name, user = PgRls.username, schema = PgRls.schema) ⇒ Object 



11
12
13
14
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_policies.rb', line 11

def enable_table_rls(table_name, user = PgRls.username, schema = PgRls.schema)
  execute_sql!(create_rls_policy_sql(schema, table_name, user))
  execute_sql!(enable_row_level_security_sql(schema, table_name))
end