Thread: 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