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 .