sparse-intern-71089
01/12/2021, 8:55 PMgentle-diamond-70147
01/12/2021, 8:56 PMquaint-electrician-41503
01/12/2021, 8:57 PMdef __createRole(self, role_name, password):
role = postgresql.Role(
f"{role_name}-rsc",
name=role_name,
login=True,
password=password,
opts=ResourceOptions(provider=self.postgresProvider),
),
export("role", type(role))
print(f"the type of role: {type(role)}")
return (role_name, password, role)
quaint-electrician-41503
01/12/2021, 8:57 PMdef __grantAccess(self, database_name, role_name, database, role):
export(
"grant",
postgresql.Grant(
f"table-grant-${role_name}-${database_name}",
database=database_name,
object_type="table",
privileges=["SELECT", "DELETE", "INSERT", "UPDATE"],
role=role_name,
schema="public",
opts=ResourceOptions(provider=self.postgresProvider, depends_on=[database, role]),
),
)
export(
"grant",
postgresql.Grant(
f"db-grant-${role_name}-${database_name}",
database=database_name,
object_type="database",
privileges=["CREATE", "CONNECT", "TEMPORARY"],
role=role_name,
schema="public",
opts=ResourceOptions(provider=self.postgresProvider, depends_on=[database, role]),
),
)
quaint-electrician-41503
01/12/2021, 8:58 PMthe type of role: <class 'tuple'>
quaint-electrician-41503
01/12/2021, 9:00 PMquaint-electrician-41503
01/12/2021, 9:59 PMgentle-diamond-70147
01/12/2021, 10:09 PMquaint-electrician-41503
01/13/2021, 2:26 AM