RE: grants on a schema
Date: Fri, 11 Jan 2013 15:34:25 -0600
Message-ID: <FD98CB0EE75EEA438CAF4DA2E6071C42234EF2F58B_at_MAIL.solutionary.com>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Friday, January 11, 2013 2:07 PM
To: Brian Zelli
Cc: oracle-l (oracle-l_at_freelists.org)
Subject: Re: grants on a schema
On Fri, Jan 11, 2013 at 11: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
>
>
>
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
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jan 11 2013 - 22:34:25 CET