Hi Shridhar,

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?

Kind regards,
Alexander Priem.

> On Wednesday 18 February 2004 13:38, Alexander Priem wrote:
> > Is there a way in which I can give rights to a user for a set of
> > tables/views/sequences WITHOUT having to name all of the
> > table/view/sequence names?
>
> You can use schemas. Just put everything under schema and grant user rights to
> the schema...
>
> HTH
>
> Shridhar
>

Met vriendelijke groet,

Alexander Priem
CICT Solutions
Email: ap@cict.nl
Internet: www.cict.nl