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.

Other related posts: