Re: Grant ALL on schema

On Thu, Mar 10, 2005 at 09:01:21 -0800,
Hemapriya <priyam_1121(at)yahoo(dot)com> wrote:
> Hi,
>
> Can anybody know how the following statement work.
>
> Grant ALL on SCHEMA test to user 'user1';
>
> will the user be able to have all the privileges on
> all the objects/tables on schema test? Or he can only
> create new objects in that schema.

That will grant CREATE and USAGE access to the schema, so that the user
will be able to look up objects in the schema and create new objects
in the schema. It won't change the access rights associated with objects
in the schema.