Hi Shridhar,<BR><BR>I created some schemas, as you seggested, but the only rights I can apply to a schema are 'usage' and 'create'. Is it possible to assign 'select', 'insert' and 'update' rights to an entire schema?<BR><BR>Kind regards,<BR>Alexander Priem.<BR><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>Met vriendelijke groet,<BR><BR>Alexander Priem<BR>CICT Solutions<BR>Email: ap(at)cict(dot)nl<BR>Internet: www.cict.nl<BR>