How to grant access to tables without specific prefix in postgres to a user?

Viewed 18

I have a database named something. I want to create a user and get access to all tables in this database except the tables with a specific prefix. Imagine this is my database with the below tables:

users
cards
directus_roles
directus_files
directus_users

I want to have a user in my Postgres who can't access those tables with the directus prefix.

0 Answers
Related