Обсуждение: Grant ALL on schema

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.

Thanks
Priya




__________________________________
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.
http://promotions.yahoo.com/new_mail

On Thu, Mar 10, 2005 at 09:01:21 -0800,
  Hemapriya <priyam_1121@yahoo.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.