Temporary users to restrict db access of query?

by tomitheninja   Last Updated June 12, 2019 07:05 AM

I am new to database managment, and I am wondering if it is a good idea to create temporary users to restrict access to only a single table.

Like having an user named _logs can only (read?) and insert to the logs table.

I am unescaping the values and I am using environments vars, but I think it would be more secure, but is it possible and a good practise?

I am using Node.JS and Postgres if it matters.

Related Questions

Index / Unique on `deleted_at` column?

Updated December 06, 2018 22:05 PM

Elasticsearch and relational database combination

Updated March 05, 2016 01:02 AM