Requirements

Name	Version
postgresql	1.13.0

Providers

Name	Version
postgresql	1.13.0
random	3.6.0

Modules

No modules.

Resources

Name	Type
postgresql_database.simple	resource
postgresql_default_privileges.admin_function	resource
postgresql_default_privileges.admin_sequence	resource
postgresql_default_privileges.admin_table	resource
postgresql_default_privileges.read_only_function	resource
postgresql_default_privileges.read_only_sequence	resource
postgresql_default_privileges.read_only_table	resource
postgresql_default_privileges.read_write_function	resource
postgresql_default_privileges.read_write_sequence	resource
postgresql_default_privileges.read_write_table	resource
postgresql_extension.assets_postgis	resource
postgresql_grant.admin_db	resource
postgresql_grant.read_only_db	resource
postgresql_grant.read_write_db	resource
postgresql_grant.revoke_database	resource
postgresql_grant_role.users	resource
postgresql_role.admin	resource
postgresql_role.read_only	resource
postgresql_role.read_write	resource
postgresql_role.users	resource
random_password.users	resource

Inputs

Name	Description	Type	Default	Required
databases	List of databases that will be created.	list(string)	[ "db1", "db2", "db3", "db4", "db5", "db6", "db7", "db8", "db9", "db10" ]	no
provider_config	n/a	map(any)	{ "connect_timeout": "22", "database": "postgres", "host": "postgres", "port": "5432", "sslmode": "disable", "username": "postgres" }	no
provider_pass	n/a	string	"letmein"	no
users	Map of user roles that will be created with the appropriate privileges (Admin or Read_Write or Read_Only) to be granted to those users.	map(object({ admin = list(string), read_write = list(string), read_only = list(string) }))	{ "user_1": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_10": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_2": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_3": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_4": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_5": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_6": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_7": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_8": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] }, "user_9": { "admin": [ "db1", "db2", "db3" ], "read_only": [ "db7", "db8", "db9", "db10" ], "read_write": [ "db4", "db5", "db6" ] } }	no

Outputs

No outputs.