module Mysqlman::PrivsGrant

Public Instance Methods

grant(priv, debug = false) click to toggle source
# File lib/mysqlman/privs_grant.rb, line 9
def grant(priv, debug = false)
  query = "GRANT #{priv[:type]} ON #{target_lebel(priv)} TO #{user_info}"
  @conn.query(query) unless debug
  @logger.info(query)
end
revoke(priv, debug = false) click to toggle source
# File lib/mysqlman/privs_grant.rb, line 3
def revoke(priv, debug = false)
  query = "REVOKE #{priv[:type]} ON #{target_lebel(priv)} FROM #{user_info}"
  @conn.query(query) unless debug
  @logger.info(query)
end

Private Instance Methods

target_lebel(priv) click to toggle source
# File lib/mysqlman/privs_grant.rb, line 21
def target_lebel(priv)
  "#{priv[:schema] || '*'}.#{priv[:table] || '*'}"
end
user_info() click to toggle source
# File lib/mysqlman/privs_grant.rb, line 17
def user_info
  "'#{@user.user}'@'#{@user.host}'"
end