Re: grants on a schema

option 1 :

extract the grants from an existing schema using dbms_metadata and repeat the scripts by changing the schema name

option 2:

presuming that you would want to grant same set of grants in the same db for multiple schemas.You could possibly create role and assign the grants to the role and grant the role. remember pl/sql needs explicit grants and this option would not work.

Best Regards

Sriram Kumar

On Sat, Jan 12, 2013 at 3:47 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org>wrote:

> I've googled this but can you do grants on a schema? I have a little proc
> that could loop thru and run the grant but I thought that maybe there was a
> one-liner to do it.....
> ciao,
> Brian
>
>
>
> This email message may contain legally privileged and/or confidential
> information. If you are not the intended recipient(s), or the employee or
> agent responsible for the delivery of this message to the intended
> recipient(s), you are hereby notified that any disclosure, copying,
> distribution, or use of this email message is prohibited. If you have
> received this message in error, please notify the sender immediately by
> e-mail and delete this email message from your computer. Thank you.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l