Originally posted by mppt
How to create a user with only select priveleges? Or how to revoke priveleges of update, delete and insert from all tables on a quick way?
Imagine that you have a system with 3000 tables ...
Hope someone may help.
Thank you in advance,
Revoke all on tablename from public;
Grant connect to user;
Grant select, insert, update, delete on tablename to user;