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