Hi
I have been struggling with this for half a day but could be my lacking knowledge of PostgreSQL. I have a database and I want to gran full privileges on it to a particular user. This is what the psq query for that looks like:
psql -U postgres -c “GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO random_user” random_database
What would be the equivalent to this using the priv directive in that module? I tried “priv=ALL” but that didn’t work and when I try “ALL/ALL:ALL” I get a complaint that relation “ALL” doesn’t exist. Does that mean the only way is to list the tables one by one?
Regards
Navid