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>&gt; On Wednesday 18 February 2004 13:38, Alexander Priem wrote:<BR>&gt; &gt; Is there a way in which I can give rights to a user for a set of<BR>&gt; &gt; tables/views/sequences WITHOUT having to name all of the<BR>&gt; &gt; table/view/sequence names?<BR>&gt; <BR>&gt; You can use schemas. Just put everything under schema and grant user rights to <BR>&gt; the schema...<BR>&gt; <BR>&gt; HTH<BR>&gt; <BR>&gt; Shridhar<BR>&gt; <BR>&gt; <BR>&gt; ---------------------------(end of broadcast)---------------------------<BR>&gt; TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org<BR><BR>Met vriendelijke groet,<BR><BR>Alexander Priem<BR>CICT Solutions<BR>Email: ap@cict.nl<BR>Inte
 rnet: www.cict.nl<BR>