Create a user, and give that user select permissions on a given DB

netezza_create_user_with_perms.md

Reference

Create User

CREATE USER User WITH PASSWORD 'password';

Check current perms after each step by using the following command:

\dpu User;

Grants list privileges. Without it, user cannot list tables in aginity when selecting a DB

GRANT SELECT, LIST ON [DB] TO User;

Grants select on all tables in a DB, to a user

GRANT SELECT ON [DB].ALL.TABLE TO User;