Class: Gitlab::Database::Grant

Inherits:
Object
  • Object
show all
Defined in:
lib/gitlab/database/grant.rb

Overview

Model that can be used for querying permissions of a SQL user.

Class Method Summary collapse

Class Method Details

.create_and_execute_trigger?(table) ⇒ Boolean

Returns true if the current user can create and execute triggers on the given table.

Returns:

  • (Boolean) 


9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
# File 'lib/gitlab/database/grant.rb', line 9

def self.create_and_execute_trigger?(table)
  # We _must not_ use quote_table_name as this will produce double
  # quotes on PostgreSQL and for "has_table_privilege" we need single
  # quotes.
  connection = ApplicationRecord.connection
  quoted_table = connection.quote(table)

  begin
    connection.select_one("SELECT has_table_privilege(#{quoted_table}, 'TRIGGER')").present?
  rescue ActiveRecord::StatementInvalid
    # This error is raised when using a non-existing table name. In this
    # case we just want to return false as a user technically can't
    # create triggers for such a table.
    false
  end
end