Granting the privileges of existing objects within a schema to a new role

How do I grant all privileges for a schema that has a large number of existing tables, procedures, functions, etc to a newly created role, without having to issue a grant statement for each object and each privilege? I want the role to have all of the rights of the schema owner.

Is there any kind of blanket granting of all privileges to a role? Received on Wed Sep 15 2004 - 13:12:14 CDT