Re: Granting privileges to objects in a schema

From: Steve M <steve.mcdaniels_at_vuinteractive.com>
Date: Thu, 19 Sep 2002 16:05:41 -0700
Message-ID: <amdl6d$882$1@spiney.sierra.com>

look at USER_OBJECTS in the relevant schema.

also consider building a script like:

select 'SELECT GRANT SELECT ON ' || object_name || ' TO myusername;' from user_objects

"Ross Barratt" <rbarratt_at_tygersoft.com.au> wrote in message news:62fdd766.0209181222.8018c2_at_posting.google.com...
> Hi Folks,
>
> I need to grant privileges to all objects in a schema to a particular
> role. I can do this manually ( grant priv on object to role ....) but
> there is more than 600 objects. I am sure that somebody has a script
> to automate this process. If you do have such a script could you
> please email/post me a copy.
>
> Thankyou very much.
Received on Thu Sep 19 2002 - 18:05:41 CDT