RE: grant select on SCOTT.* to vewalluser;

From: Roger Xu <Roger.Xu_at_dp7upbg.com>
Date: Tue, 31 Oct 2006 11:35:59 -0600
Message-ID: <A6801E8A03316A4DA597866F77A013F70C8D452B@irv2kexch01.tx.bg.corp>

Then each time SCOTT creates a new table, I have to do the following?  

grant select on SCOTT.newtablename to vewalluser;  

-----Original Message-----

From: David Sharples [mailto:davidsharples_at_gmail.com] Sent: Tuesday, October 31, 2006 11:37 AM To: Roger Xu
Cc: Oracle-L_at_Freelists. Org (E-mail)
Subject: Re: grant select on SCOTT.* to vewalluser

nope, there is no way do grant everything to a user in one command

On 31/10/06, Roger Xu < Roger.Xu_at_dp7upbg.com> wrote:

Hi List,
Is there a simple way to do this besides the following?

This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o

---

This email has been scanned for all viruses by the MessageLabs Email Security System.
--

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