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@xxxxxxxxx] Sent: Tuesday, October 31, 2006 11:37 AM To: Roger Xu Cc: Oracle-L@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@xxxxxxxxxxx> 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.