<p>Hi guys,<p>I have a fairly big PostgreSQL 7.4.0 database running here and I am currently busy managing the rights of
thedifferent database users. I have a lot of tables, vieuws, sequences etc.<p>If I use Grant / Revoke to manage user
rights,I have to name all of the different tables/views to grant or revoke a right. For instance, I cannot say
somethinglike 'Revoke Select on all tables' followed by 'Grant Select on all views' so users can only access data
throughviews. There is only something like 'Grant Select on database xxx'...<p>Is there a way in which I can give
rightsto a user for a set of tables/views/sequences WITHOUT having to name all of the table/view/sequence
names?<p>Thanksin advance.<p>Alexander Priem