Re: grants on a schema

From: Jared Still <>
Date: Fri, 11 Jan 2013 12:06:53 -0800
Message-ID: <>

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 - 21:06:53 CET

Original text of this message