RE: grants on a schema

From: Don Granaman <>
Date: Fri, 11 Jan 2013 15:34:25 -0600
Message-ID: <>

You haven't missed anything. Other than with the (justifiably) highly discouraged A-bomb of granting "% ANY %" system privileges, there is no way to grant privileges on every object in a schema.

Don Granaman | Ph: 402-361-3073 | Cell: 402-960-6955 | Solutionary - Relevant | Intelligent | Security

-----Original Message-----
From: [] On Behalf Of Jared Still Sent: Friday, January 11, 2013 2:07 PM
To: Brian Zelli
Cc: oracle-l ( Subject: Re: grants on a schema

On Fri, Jan 11, 2013 at 11: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

grant DBA to <username>;

But on a more serious note, I don't believe that can be done. Unless I've missed something (else) in more recent documentation.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: Home Page:


Received on Fri Jan 11 2013 - 22:34:25 CET

Original text of this message