Role creation with knexjs

Question

I am new to PostgreSQL and node. I am using knex.js library. I need to create roles and assigned it to each table I created in PostgreSQL. I am not sure how can I achieve it. Is it to be done at the time of table migration? Or can I do it after migration? And if so how can I do it?

Answer 1

I have no experience with knex, but I suppose you can use

knex.raw('create user blah password 'blah-blah') 

to create user. Of course your knex postgres user needs CREATE ROLE privs for it.

Assigning permissions on created tables to users might be done same way I suppose, eg:

knex.raw('grant select, update on table blah_blah to user blah') 

this should not require any additional permissions for knex db user, as It creates tables and thus is the owner.

Answer 2

As others has mentioned, you need to use knex.raw and raw SQL statements (in this case postgresql flavor). Knex doesn't have any special APIs supporting setting roles.