Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: grant select on SCOTT.* to vewalluser

Re: grant select on SCOTT.* to vewalluser

From: rjamya <rjamya_at_gmail.com>
Date: Tue, 31 Oct 2006 12:48:34 -0500
Message-ID: <9177895d0610310948r6f40fcw52fa30de73a57343@mail.gmail.com>


That is the simplest, the way you wrote it. You can make it better be filtering out tables on which you already have granted privs.

Raj

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 31 2006 - 11:48:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US