Ah. In that case schema's are of no use for me. I just want an easy way to give users different rights on tables/views, without having to specify every single table and view. Maybe this is something that needs to be changed in a future release? I have many many tables and views and having to specify every single one of them is just a drag...<BR><BR>Kind regards,<BR>Alexander Priem.<BR><BR><BR>> On Thursday 19 February 2004 15:43, Alexander Priem wrote:<BR>> > Hi Shridhar,<BR>> ><BR>> > I created some schemas, as you seggested, but the only rights I can apply<BR>> > to a schema are 'usage' and 'create'. Is it possible to assign 'select',<BR>> > 'insert' and 'update' rights to an entire schema?<BR>> <BR>> No. You can not do that. You have to grant those right on the objects. Howe> ver <BR>> while revoking them you can just revoke the schema rights and the objects <BR>> will be inaccessible to that user.<BR>> <BR>> HTH<B
R>> <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>