Packages

formation

0.13.2
0.16.3 0.16.2 0.16.1 0.15.2 0.15.1 0.15.0 retired 0.14.3 0.14.2 0.14.1 0.14.0 0.13.2 0.13.1 0.13.0 0.12.5 0.12.4 0.12.2 0.11.3 0.11.2 0.11.1 0.11.0 0.10.1 0.10.0 0.9.3 0.9.2 0.9.1 0.9.0 0.8.1 0.8.0 0.7.0 0.6.0 0.5.0 0.4.3 0.4.2 0.4.1 0.4.0 0.3.1 0.3.0 0.2.0 0.1.2

Abstractions for managing infrastructural components.

HexDocs

Current section

Files

Jump to
Readme
39 Versions
5 Dependencies
Dependants
Files
Activity
formation lib formation postgresql user.ex
Raw

lib/formation/postgresql/user.ex 

defmodule Formation.Postgresql.User do

  def create(pid, username, password) do

    Postgrex.query(pid, "CREATE USER #{username} WITH ENCRYPTED PASSWORD '#{password}'", [])

  end



  def grant_role(pid, new_user, master_user) do

    Postgrex.query(pid, "GRANT #{new_user} TO #{master_user}", [])

  end



  def grant_all(pid, username, database) do

    Postgrex.query(pid, "GRANT ALL PRIVILEGES ON DATABASE #{database} TO #{username}", [])

  end



  def grant_public_schema(pid, username) do

    Postgrex.query(pid, "GRANT ALL ON SCHEMA public TO #{username}", [])

  end

end