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,

MPpt

Hi there,


Revoke all on tablename from public;
Grant connect to user;
Grant select, insert, update, delete on tablename to user;


Regards,

lloyd

Hi lloyd,

I thank you for your help. However my problem is that I do not wish to grant or revoke priveleges table by table. Is there anyway to revoke or grant priveleges to all tables at once?

Regards,

MPpt