Is there a shortcut to grant a privilege on all tables or views or both of a database instead of once a table or view?

Thanks in advance,

Eric Du
-----------------------------------
Tel: (86-010) 65544068-309
Fax: (86-010) 65544066