Granting the privileges of existing objects within a schema to a new role
From: Ted <steadman_at_ceva.net>
Date: 15 Sep 2004 11:12:14 -0700
Message-ID: <39d8ada9.0409151012.7da37d1e_at_posting.google.com>
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.
Date: 15 Sep 2004 11:12:14 -0700
Message-ID: <39d8ada9.0409151012.7da37d1e_at_posting.google.com>
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 - 20:12:14 CEST