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,
withouthaving 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
/>Kindregards,<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
rightsI 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
thoseright 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="R">> <br />> Shridhar<br /><br
/><br/>Met vriendelijke groet,<br /><br />Alexander Priem<br />CICT Solutions<br />Email: ap@cict.nl<br />Internet:
www.cict.nl<br/></b>
