Thanks for your reply.<BR><BR>I already have all the tables/views/sequences set up and filled. Can I create a new schema and 'assign' the existing tables/views/sequences to this new schema? Will this affect current queries I have created?<BR><BR>Kind regards,<BR>Alexander Priem.<BR><BR><BR>> On Wednesday 18 February 2004 13:38, Alexander Priem wrote:<BR>> > Is there a way in which I can give rights to a user for a set of<BR>> > tables/views/sequences WITHOUT having to name all of the<BR>> > table/view/sequence names?<BR>> <BR>> You can use schemas. Just put everything under schema and grant user rights to <BR>> the schema...<BR>> <BR>> HTH<BR>> <BR>> Shridhar<BR>> <BR>> <BR>> ---------------------------(end of broadcast)---------------------------<BR>> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org<BR><BR>Met vriendelijke groet,<BR><BR>Alexander Priem<BR>CICT Solutions<BR>Email: ap(at)cict(dot)nl<BR>Inte
rnet: www.cict.nl<BR>