Create an AWS postgres user

Create additional postgres users using the following as the tts_admin user if you need to:

--create user

create user data_analytics with encrypted password 'PASSWORD_HERE';

--grant schema access

grant usage on schema bitool to data_analytics;

--grant table access

grant select on all tables in schema bitool to data_analytics;

--grant access to future tables

alter default privileges in schema bitool grant select on tables to data_analytics;

--run queries as new user

set session authorization data_analytics;

--test select

select * from bitool.cookie_tracking_raw_data ctrd;

--reset session to original user

reset session authorization;