def grant_db_access(conn, schema, table, role):
    """Gives access to database users/ groups

    Parameters
    ----------
    conn : sqlalchemy connection object
        A valid connection to a database
    schema : str
        The database schema
    table : str
        The database table
    role : str
        database role that access is granted to

    """
    grant_str = (
        """GRANT ALL ON TABLE {schema}.{table}
    TO {role} WITH GRANT OPTION;"""
        .format(schema=schema, table=table, role=role))
    conn.execute(grant_str)
