Re: grants on a schema
From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 11 Jan 2013 12:06:53 -0800
Message-ID: <CAORjz=PyybVB-gDpqz6yj3+zFBnpDi1FpkOArKhEpeWAYePUpA_at_mail.gmail.com>
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>;
Date: Fri, 11 Jan 2013 12:06:53 -0800
Message-ID: <CAORjz=PyybVB-gDpqz6yj3+zFBnpDi1FpkOArKhEpeWAYePUpA_at_mail.gmail.com>
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-lReceived on Fri Jan 11 2013 - 21:06:53 CET