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