Module: PgRls::ActiveRecord::ConnectionAdapters::PostgreSQL::RlsUserStatements

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

Overview

This module contains the logic to grant user privileges

Instance Method Summary collapse

Instance Method Details

#assign_user_to_group(name) ⇒ Object 



41
42
43
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 41

def assign_user_to_group(name)
  execute_sql!(assign_user_to_group_sql(name))
end

#create_rls_group(name = PgRls.rls_role_group) ⇒ Object 



33
34
35
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 33

def create_rls_group(name = PgRls.rls_role_group)
  execute_sql!(create_rls_group_sql(name))
end

#create_rls_role(name, password) ⇒ Object 



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

def create_rls_role(name, password)
  create_rls_user(name, password)
  assign_user_to_group(name)
end

#create_rls_user(name, password) ⇒ Object 



29
30
31
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 29

def create_rls_user(name, password)
  execute_sql!(create_rls_user_sql(name, password))
end

#drop_rls_group(name = PgRls.rls_role_group) ⇒ Object 



37
38
39
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 37

def drop_rls_group(name = PgRls.rls_role_group)
  execute_sql!(drop_rls_group_sql(name))
end

#drop_rls_role(name) ⇒ Object 



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

def drop_rls_role(name)
  remove_user_from_group(name)
  drop_rls_user(name)
end

#drop_rls_user(name) ⇒ Object 



25
26
27
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 25

def drop_rls_user(name)
  execute_sql!(drop_rls_user_sql(name))
end

#remove_user_from_group(name) ⇒ Object 



45
46
47
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 45

def remove_user_from_group(name)
  execute_sql!(remove_user_from_group_sql(name))
end

#user_exists?(name) ⇒ Boolean

Returns:

  • (Boolean) 


21
22
23
 
# File 'lib/pg_rls/active_record/connection_adapters/postgre_sql/rls_user_statements.rb', line 21

def user_exists?(name)
  execute_sql!(user_exists_sql(name)).first.present?
end