Re: Grant / Revoke functionality

On Wed, 18 Feb 2004, Shridhar Daithankar wrote:

> 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...
>

This is not accurate.  The only schema level permissions are CREATE and
USAGE they are independent of the permissions on the objects contained
within.  He would still need to grant access to the underlying objects.

Kris Jurka