RE: grant select on SCOTT.* to vewalluser;

From: "Roger Xu" <Roger.Xu@xxxxxxxxxxx>
To: "David Sharples" <davidsharples@xxxxxxxxx>
Date: Tue, 31 Oct 2006 11:35:59 -0600

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.

Follow-Ups:

Re: grant select on SCOTT.* to vewalluser;
From: David Sharples

RE: grant select on SCOTT.* to vewalluser;
From: Wolfgang Breitling

RE: grant select on SCOTT.* to vewalluser;

Other related posts: