Re: grants on a schema

From: Sriram Kumar <>
Date: Sat, 12 Jan 2013 09:58:57 +0800
Message-ID: <>

I can think of 2 options

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 <>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.
> --

Received on Sat Jan 12 2013 - 02:58:57 CET

Original text of this message