On Thursday 19 February 2004 15:43, Alexander Priem wrote:
> 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?
No. You can not do that. You have to grant those right on the objects. However
while revoking them you can just revoke the schema rights and the objects
will be inaccessible to that user.
HTH
Shridhar