Grant ALL on schema

От:

Hemapriya <priyam_1121@yahoo.com>

Дата:

14 марта 2005 г. в 02:11:31

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