On Wednesday 18 February 2004 08:45, Shridhar Daithankar wrote: > On Wednesday 18 February 2004 13:38, Alexander Priem wrote: > > Is there a way in which I can give rights to a user for a set of > > tables/views/sequences WITHOUT having to name all of the > > table/view/sequence names? > > You can use schemas. Just put everything under schema and grant user rights > to the schema...
Also - have a look on techdocs.postgresql.org - before we had schemas someone had written a plpgsql function to do wildcard matching of table names, also a shell-script/perl iirc. -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org