​

Creating a service account user

​

1. Access PostgreSQL

Open your PostgreSQL client or connect to the database server using the psql command-line tool:

psql -U postgres

​

2. Create the service user

Use the CREATE USER command to define the user and assign a secure password:

CREATE USER service_user WITH PASSWORD 'secure_password';

• Replace service_user with your desired username.
• Replace secure_password with a strong password.

​

3. Grant necessary privileges

Fabi.ai needs read access to the schemas that you wish to query.

To grant the ability to connect to a database:

GRANT CONNECT ON DATABASE your_database TO service_user;

To give access to specific schemas:

GRANT USAGE ON SCHEMA your_schema TO service_user;

To allow the user to read from tables:

GRANT SELECT ON ALL TABLES IN SCHEMA your_schema TO service_user;

Optional: To automatically grant privileges on new tables:

ALTER DEFAULT PRIVILEGES IN SCHEMA your_schema GRANT SELECT ON TABLES TO service_user;

PostgreSQL Documentation: Privileges

​

Connecting PostgreSQK to Fabi.ai

Once you’ve generated your service user credentials, follow the steps in Connecting to Your Data