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
/>Kindregards,<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/sequencesWITHOUT having to name all of the<br />> > table/view/sequence names?<br />> <br />>
Youcan 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
/>CICTSolutions<br />Email: ap@cict.nl<br />Internet: www.cict.nl<br />