RE: grants on a schema

  • From: Don Granaman <DonGranaman@xxxxxxxxxxxxxxx>
  • To: "jkstill@xxxxxxxxx" <jkstill@xxxxxxxxx>, Brian Zelli <Brian.Zelli@xxxxxxxxxxxxxxx>
  • Date: Fri, 11 Jan 2013 15:34:25 -0600

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: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Jared Still
Sent: Friday, January 11, 2013 2:07 PM
To: Brian Zelli
Cc: oracle-l (oracle-l@xxxxxxxxxxxxx)
Subject: Re: grants on a schema

On Fri, Jan 11, 2013 at 11:47 AM, Zelli, Brian
<Brian.Zelli@xxxxxxxxxxxxxxx>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: 
http://jkstill.blogspot.com Home Page: http://jaredstill.com


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


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


Other related posts: