[GENERAL] granting privileges

[Nageshwar Rao]

How to grant privileges to all objects( tables,sequences etc) in specific schema, I mean I want to give users select,insert,delete and update to all objects in the schema in one sql statement.I know   Grant select,insert,update,delete on table_name to user_name.  But this is for individual table .