All,
How can you grant privileges to a user to all tables in database?
For example I have 5 tables in database A. And now I want to give
SELECT/UPDATE/INSERT privileges to a user to all 5 tables. But according to
documentation, I have to execute 'GRANT' query 3 times(for
select/update/insert) per table. meaning total of 15 times!!!!
Is there any way I can do that in just one shot?
Basically I want to give user privileges to all tables in databse at once.
Like we can do in MySQL by adding a user in 'db' and 'user' table.
Is it possible in PostgreSQL? How?
Thanks in advance..
Niral