Workflow to grant read (SELECT) privilege to all users in NSAPH admin role
Workflow
Description
This workflow executes an SQL statement in the database to grant read priviligies to NSAPH users (memebrs of group nsaph_admin) This is a wrapper around the tool to be called from Airflow DAG.
Inputs
Name |
Type |
Default |
Description |
|---|---|---|---|
database |
File |
Path to database connection file, usually database.ini |
|
connection_name |
string |
The name of the section in the database.ini file |
|
sql |
string[] |
|
Outputs
Name |
Type |
Description |
|---|---|---|
grant_log |
File |
|
grant_err |
File |
Steps
Name |
Runs |
Description |
|---|---|---|
grant |
Grants read access to the members of NSAPH group for newly created or updated tables |